Unique reports

  • Thread starter Thread starter Pastor Del
  • Start date Start date
P

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?
 
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.
 
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?
Click to expand...

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.
 
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?
 
Back
Top