Date Conditional Format in sub form

[veasna]

Dear Access members,

In my Index form have a sub form name "Driver Booking subform". In "Driver Booking subform" i have a field name "Date_From" and i want to put the conditional format(red background color) to this field. ***if the value of this field is equal to CuurentDate (eg. 26/12/2009)***

Could you please help me to deal with this?

Thanks,
Veasna.

 

[boblarson]

Open the subform in design view. Select the text box and then if in Access 2002-2003 click FORMAT > CONDITIONAL FORMATTING and if in Access 2007 Right-Click your mouse on the text box and select CONDITIONAL FORMATTING.

Then, in the Condition1 the first drop down should say FIELD VALUE IS and then in the second, select EQUAL TO and then type Date()

 

[veasna]

Dear boblarson,

Thanks you very much for your time and your answer.

Thanks,
Veasna