How do I set up a Macro to change text color in a report?

K

kamholtzj1

I need to create a Macro that changes the color of text in a report based on
the criteria I set. Can anyone help? I know it's possible to do, but I
cannot find anything on that in my materials? I am using Access 2003.


Thank you!
Janette Kamholtz
(e-mail address removed)
 
T

tina

take a look at Conditional Formatting. open the report in design view, click
on the control that holds the text, and click Format | Conditional
Formatting on the menu bar.

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
Need Help with Macro Security 1
Access 2002 change report header text 0
Excel does not accept text format! 0
How do I set focus (and select text) on a text box on a modeless userform? 0
How do I convert shading to highlighting for specific colors 8
VBA word change keys 0
Select text of a particular shading color (VBA macro) 5

Top