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
 
You must log in or register to reply here.

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

Conditional Formatting with Dates 4
Conditional Formatting 5
Conditionally Format Particular Dates 1
Conditional Formatting for Dates - nothing seems to work 4
Excel Message box with days of month & date. 1
Conditional formatting dates 3
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Conditional Formatting Dates 2

Back
Top