Bill Benson
bensonforums at gmail.com
Fri May 16 00:38:52 CDT 2014
I can think of some other ways to do this but I would like your input.
I have a listbox which I am populating with event descriptions and completion, and I would like a signal other then
Completed
Yes
Yes
No
I would like
Completed
√
√
Now, in case that does not display, it is Alt-251 which is a check-mark. If I enter that into a table record, it displays appropriately – indicating I could make this happen in the listbox using Short Text as a field type. I know I could also display a completion date instead of a Yes/No, but in this case I do not wish to.
I tried instead a rowsource like this: SELECT [ID], [Description], iif([Completed],CHR(251),"") AS Done FROM Events
And that is showing something like û (I believe it is a “mu”?). Same if CHRW(251) instead of CHR(251).
I believe that √ (251) and û (0251) are quite different. Is there any function in Access that will return Alt-251 instead of Alt-0251 in a query?