Checkmark in Access Report

[pattyjean]

Access 2007

I have data in a table that has values of M and S and I need to change them in a report to show as a Checkmark.
Any Ideas?

 

[MajP]

lowercase "a" in webdings is a check.
put an unbound control on a form and font is webdings
controlSource:=IIf([fieldName]="M" Or [fieldName]="S","a","")

 

[Gammachaser]

Assuming 'M' = True, put a CheckBox in the report and set its ControlSource to:

=Iif([i]fieldname[/i] = "M", True, False)

Change as needed for the actual 'True' value. Make sure fieldname is part of the report's RecordSource.

 

[Gammachaser]

OK, so MajP assumed that both 'M' and 'S' are True, and I assumed one was True and one False. Rereading your post, he is probably correct. Either way will work for the appropriate case.

 

[MajP]

I was also assuming a check not an X. Either interpretation could be correct.

 

[pattyjean]

Thank you both for your answers. I did find out if I change the m and s to P and wingdings 2 it will work also. Thank you thank you.

 

[pattyjean]

All 3 ways work PERFECTLY!!!