How to handle the next record during report processing

[Goot]

In my report detail, I have a number of check box values I would like to display the value of, but ONLY IF THEY HAVE BEEN CHECKED. I set all the checkbox controls to invisible, So, in my detail section, I check the value of the checkbox, if -1 then I make them visible.

PROBLEM is, once I have a record where the value is true, it is displaying true for all the records in the report.
How can I reset the value to visible before printing the next record.

 

[dhookom]

You need code in the On Format event of the section containing the controls. Remember the code needs to use [blue]If..Then[/blue] sections to hide or show the controls.

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]

 

[Goot]

Perfect, Thank you.