Unique reports

[Pastor Del]

I need to print multiple reports, each report representing a record in a
table. Is there anyway to automatically change the back color of one of the
report controls depending on the data in that particular record?

 

[Daniel Pineault]

Yes. You could code it using vba or, even simpler, use conditional formatting.

Select the control in question and the select Format -> Conditional
Formatting...
Then simply create your rule
Close and save your changes
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[John W. Vinson]

I need to print multiple reports, each report representing a record in a
table. Is there anyway to automatically change the back color of one of the
report controls depending on the data in that particular record?

Are these different Access Reports - with different fields, different layout,
different structure?

Or do you want multiple *sheets of paper*, all similar?

You can change the back color of a control in Report design view by selecting
the control, and choosing Format... Conditional Formatting from the menu.

 

[Pastor Del]

Thanks, the conditional formatting works great. As far as vba, I tried the
following code without success:

Reports!Report1!Text0.BackColor = 255

What was I doing wrong?