Conditional formating of dates in a form

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I am trying to get a date to turn red after the date specified has passed.
I tried this code from one of the other posts here, and no luck with it
working.

[forms]![frmMyFormName]![txtMyTextBoxName] < Dateserial(Year(date()),1,1)

I did change the Year to Month, and the date to today().

Thanks

Todd
 
Back
Top