...Print in Red if date is not Current...

R

Rodney

.....In my Membership Database, is there a way to print
the date in "Red" if the date is over a certain year in my report....?

.....like...

.....if the date is <01/01/03...print red...?
 
A

Allen Browne

In report design view, select the text box for the date, and choose
Conditional Formatting on the Format menu. (Requires Access 2000 or later.)
 
A

Al Camp

Rodney,
Place your logic in the OnFormat event of your report section.
If (some condition) Then
[YourDate].Forecolor = QBColor(12)
Else
[YourDate].Forecolor = QBColor(0)
End if
 
R

Rodney

......Thanks O so much....!!!!

....You guy's actually make me look professional.......LoL....
 
Top