Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Formating - Date Fields

Status
Not open for further replies.

Quan9r

Technical User
May 18, 2000
36
US
I have a form with date fields - [Initial Date] and [8 Week Follow-up Date]

I would like to change the background to another color if the [8 Week follow-up] was not conducted ~ something like: [Initial Date]+ 56 Days

I don't know much VB and have been trying the Conditional Formatting - but it doesn't seem to work -

Eventually I would like to run a query to list those people overdue

Any help would be much appreciated!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top