Insert check sign in Listbox
- Thread starter eugz
- Start date
Tim L
Registered User.
- Local time
- Today, 18:33
- Joined
- Sep 6, 2002
- Messages
- 414
Yes and No, read on...
A check sign is available as "R" in Wingdings 2 and you could create a query that will show "R" for a given value in a Yes/No field; you would then need to change the font of the list box to Wingdings 2. This would, however, mean that the other fields are also displayed in Wingdings and you'd effectively have gibberish in them
Might it be a better idea to have Chr(164) replaced with "Yes", or "Y" or something else?
(Unless someone can provide a way of setting different fonts for different columns in a list box?)
You could use
HTH
Tim
A check sign is available as "R" in Wingdings 2 and you could create a query that will show "R" for a given value in a Yes/No field; you would then need to change the font of the list box to Wingdings 2. This would, however, mean that the other fields are also displayed in Wingdings and you'd effectively have gibberish in them
Might it be a better idea to have Chr(164) replaced with "Yes", or "Y" or something else?(Unless someone can provide a way of setting different fonts for different columns in a list box?)
You could use
Field3: IIF(tableName.Field3=Chr(164),"Yes","")
as a field in the query for the listbox to get "Yes" (where Chr(164) is in Field3) or a blank to show in your listbox for Field3; you can change the "Yes" to whatever suits. You should untick "visible" for your current Field3 or remove it from the listing if there are no criteria on it. Note: this does not change the stored values, only those returned by the query, if you want to change the stored values use an update query.HTH
Tim
