Checkboxes in a report

[czarjosh]

I am designing a report, and I would like to have one column of it to have checkboxes, but I only want there to be a check in the box IF there is a value in a field.

For example. I am tracing people who have went to actions, I want the checkbox on the report to print out checked if their is a value in the action text box.

 

[SteveR77]

You'll need a field in your query that is set up like this -

CheckMe: IIf(Not IsNull([MyField]),0,-1)

If Myfield does not have a value then the CheckMe field gets set to 0 or the false condition for the check box, otherwise it will be set to true.

In the design of the report you would then need to set the control source of your checkbox to be CheckMe.

HTH,

Steve

 

[cghoga]

In the control source of the checkbox enter:

=IIf([YourActionCheckBox]=True,1,0)