Make color of a text box depend on the value it contains 1

[jlhaas]

I'm trying to make a report that displays date values and highlights those dates meeting certain criteria (i.e. more than 18 months old) by displaying them differently. I would prefer to do that by having the color of the text box change (or back color) but any help would be appreciated.

Thanks!

 

[btj]

My first stab at a post...if you know the criteria, you can use Conditional Formatting (under Format). It allows you to set formatting based on specific values returned for said fields.

Hope this helps...

- Ben

 

[Garridon]

You can find what you're looking for on this web site, plus a lot of other cool stuff.

http://www.rogersaccesslibrary.com/

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[ZaZa]

Linda,

I looked at the site but I didn't see any tips on conditional formatting. Can you give me a liitle more directions please?

Regards,
ZaZa

 

[Garridon]

It's under C, the first item called ChangingColorFields.

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com