Insert Special Character

tweetyksc

Registered User.
Local time
Today, 20:48
Joined
Aug 23, 2001
Messages
87
I have a report run from a query that worked fine before we moved to Windows 2000. In the query, a custom field called PPD ran an iif statement; if true, it would assign "3" to the field, if false, null.

On the report, I formatted the field for a certain font (monotype sorts) which would show a checkmark for all fields that were true (3 value). The 3 was the keystroke value of the checkmark in that font in Window's Character Map.

In Windows 2000, that font is not automatically installed. Instead of having to have people install separate fonts, I wanted to use the checkmark from the Wingdings set (unicode: 0xFC).
In windows 2000, the character map does not show a keystroke for the characters, just unicode. How do I put this in the query so the checkmark will display? I tried doing similar to before with no luck.

We are using Access 97.
 
just copy that actual character into the query:

IIF(blah, "INSERT_YOUR_CHAR_HERE", NULL)
 
Oh, who would've thought it would be so simple?
Thanks - it worked after I took out the [] and put quotes!

Thanks a bunch!
 
tweetyksc said:
Oh, who would've thought it would be so simple?
Thanks - it worked after I took out the [] and put quotes!

Thanks a bunch!

[] is used if you were referencing a field. "" is used for the actual contents or character within the quote:

IIF(Condition, "HI", [Price])

If condition is true displays HI
If condition is false displays the value stored in the field price
 

Users who are viewing this thread

Back
Top Bottom