 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / July 2005Paperclip within listbox
Ok, I know the subject sounds weird, but read on... Some background: I have an existing form in a client's application that uses a listbox on the LHS that includes a brief summary of the contents of each record. The full detail of the records is displayed on the RHS. Each record can have files attached to them that are stored independently of the BE database. The attached files can be opened, deleted, etc.. form within the form. Now my problem: The client wishes to include a paperclip in the summary down the LHS to indicate that the record has attachments. In terms of the UI this makes perfect sense. I was hoping their was already a paperclip included within most fonts - but I'm wrong. Any ideas welcome... I cannot think of a paper-clip but would your client accept the character that you get for a 2 in the Marlett font, it looks like overlapping documents? The advantage of Marlett is that it is part of Windows so you should be able to rely on it being there! I cannot think of a way to get anything like this on a listbox but you could replace it with a sub-form formatted to look like a listbox, then just select a 2 into the field for records that have documents stored. HTH John > Ok, I know the subject sounds weird, but read on... > Some background: [quoted text clipped - 9 lines] > most fonts - but I'm wrong. > Any ideas welcome... Using CharMap On "Marlet" found no entries. Font "MS Outlook" chatacter 0x47 "G" is a paper clip. Any help on your setup? - John > Ok, I know the subject sounds weird, but read on... > [quoted text clipped - 12 lines] > > Any ideas welcome... Thanks John, but... 1. Can I include 2 different fonts within the same listbox? (I think NOT). OR 2. I suspect I'll need 2 listboxes operating in parallel. The second containing the same records but SELECTing just the paperclip icon (ie, a 'G') when there are attachments (else nothing), and using the MS Outlook font. (A real pain given the existing complexities). OR 3. Don't use a paprclip, rather use a standard character to represent attachments such as 'A' or '*'. (Not as nice but really easy). Can 1. be done? Thanks, Sam > Using CharMap On "Marlet" found no entries. > Font "MS Outlook" chatacter 0x47 "G" is a paper clip. [quoted text clipped - 19 lines] >> >> Any ideas welcome... I don't think that you can do it with a list box but you could do it with a sub-form designed to look like a list box. You can then use two controls with different fonts in each. I think that will be easier than trying to synchronise two list boxes. 3 is certainly the easy option but as you say, not as nice ;-) HTH John > Thanks John, but... > 1. Can I include 2 different fonts within the same listbox? (I think NOT). [quoted text clipped - 6 lines] > 3. Don't use a paprclip, rather use a standard character to represent > attachments such as 'A' or '*'. (Not as nice but really easy). Thanks John, I've implemented my option 3. If I have time (after completing the rest of the upgrade) I'll come back and give your suggestion a whirl! Sam >I don't think that you can do it with a list box but you could do it with a >sub-form designed to look like a list box. You can then use two controls [quoted text clipped - 16 lines] >> 3. Don't use a paprclip, rather use a standard character to represent >> attachments such as 'A' or '*'. (Not as nice but really easy). Here's a slightly more elegant version of option 3: Make the first character in the list entry: If there is no attachment, U+2610 (i.e., the character at Unicode code 2610)--this is an empty box If there is an attachment, U+2611 (a checkmark in a ballot box) or U+2612, an X in a ballot box Thus is will look as though there is a column of checked or unchecked boxes followed by text. Note that you have to make sure that you have a font installed that can display this character (e.g., Arial Unicode MS, which comes with Office but is not installed by default; Tahoma also has these characters). > Thanks John, > [quoted text clipped - 25 lines] >>> 3. Don't use a paprclip, rather use a standard character to represent >>> attachments such as 'A' or '*'. (Not as nice but really easy). It should be Marlett, which is used for the Windows furniture, scroll bars etc so should be present on any PC. The MS Outlook font will presumably only be present if Outlook is installed, so may or may not be there, if you can rely on it for this client it would be a better choice having an actual paper-clip. John > Using CharMap On "Marlet" found no entries. > Font "MS Outlook" chatacter 0x47 "G" is a paper clip. > Any help on your setup? - John >Ok, I know the subject sounds weird, but read on... >>Some background: [quoted text clipped - 8 lines] >>perfect sense. I was hoping their was already a paperclip included within >>most fonts - but I'm wrong. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.