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

  • Thread starter Thread starter Rodney
  • Start date Start date
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...?
 
In report design view, select the text box for the date, and choose
Conditional Formatting on the Format menu. (Requires Access 2000 or later.)
 
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
 
......Thanks O so much....!!!!

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