Printing text based on check box.

[kjspear]

I have a question about selecting text in a report. I have a report that prints out name badges. It works fine, however, The query have check boxes on them from a form. I would like access to print the results from the check box. In other words something like this;

If PCC.value='true' then
x="Member"

I'm not too familiar with VBA, but I would it to print the results from the check box is true.


Please let me know if you need more clarification.

Thanks
Chelsea

 

[dhookom]

You should be able to use a text box with a control source like:
=IIf(PCC = True,"Member",Null)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]