Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Checkmark in Access Report

Status
Not open for further replies.

pattyjean

Technical User
Mar 3, 2006
53
US
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?
 
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","")
 

Assuming 'M' = True, put a CheckBox in the report and set its ControlSource to:
Code:
=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.
 

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.
 
I was also assuming a check not an X. Either interpretation could be correct.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top