Add a check mark via vb (1 Viewer)

[DataMinerHome]

I want to add a button to a form that, if clicked, will add a check mark to a field. There is a wingdings checkmark character, but:
1. I can't figure out how to use vb to get the wingdings character into the field.I can insert it using the windows xp character map application, but....character map says it's character code is OxFC, but where does that get me? asc("OxFC") returns 79.

2. I don't really want to set the font to wingdings because I also need the ability to type normal characters into the field. I suppose I could set up vb to change the font, but...

is there a better way?

Access 2003, WIndows XP

 

[Jeanette Cunningham]

Create a separate field for the Yes/No data.

 

[Pat Hartman]

Checkmarks are only used to indicate yes/no, on/off, true/false values. It would be confusing to use them in a control that might contain text values, which is aside from the problem that they are not in the standard character set and so won't be in a text font.