Reports & Checkboxes

[hrinterndcarc]

My manager has asked me to create a db with a form that allows her to click a checkbox if a person is willing to be called for one of our 20 locations. One of the reports she wants created contains a list of their names, date of hire, and all of the locations running across the top. If they are willing to work there the location is checked off and would like to see a check in the appropriate box in the report.

The problem arises for the locations that the employee does not want to work at. She would like the report to not have the black outline of the checkbox since it was unchecked. How would I go about making these boxes invisible when "no".

I have enclosed a jpeg of what the report looks like. Essentially I am just trying to get rid of the black outline box of a checkbox if unchecked.

I am new to this program and don't know very much still.

 

[Fear Naught]

This is just what I have been trying to do as well. I know how to do it but can't get the ASCII code for a tick (it is supposed to be 251 but that does not print as a tick)

what you need to do to get rid of the boxes if create a text boxe and have the control course set as:

IIF([FieldName] = True,[FieldName],"")

That will display the tick with the box round it. What I have been trying to do is just display a tick with the following:

IIF(FieldName] = True,CHR(251),"")

Any help on the correct number to put into the CHR() function to display just a tick will be most gratefully recieved :0

 

[Fear Naught]

I have just realised that the first bit of code above does not work correctly. The display turns out to be -1 (the real value of 'True' in a Boolean DataType.

I have now changed the code in my report to

IIF(FieldName] = True,"Yes","")

Whilst this suits my purpose at the moment I would still like to know who to just put a tick!!