Format text boxes on continuous form based on system date

[jpkeller55]

Hi, I am having trouble finding the right VBA to do this, but I have a continuous form (2003) with 6 text boxes (StartTime, StopTime, Comments etc...). I would like all the text boxes to have a gray background if the StartTime for that row is less than Today(). Any help is appreciated.

 

[vbaInet]

You can look into using Conditional Formatting.

 

[jpkeller55]

So I have to use conditional formatting for each text box? That is, I need to set each text box based on an expression related to the system time? I have been successful updating the background color of the one control using the conditional formatting function but not sure how to get the other controls to change background based on the StartTime value.

 

[vbaInet]

That's right. If it wasn't a Continuous Form you could have used VBA.

You select Expression Is instead of Field Value and write an expression that will equate to True based on Start Time's value.

 

[jpkeller55]

OK, I figured it out. Basically, I have to put this expression on each control for conditional format: [StartTime]<Date()

This works...thanks for your help!

 

[vbaInet]

Very good!