Conditional Formatting with Dates

[Richard T via AccessMonster.com]

Would someone be able to tell me the reason (and solution) that the
conditional formatting does not seem to acknowledge the whole value in a
textbox containing a date?? I have unbound textboxes programmatically
populated with dates and conditional formatting set up for those textboxes.
The condition is whether the date in one of these textboxes is between two
dates (2 bound controls). However, it's only reading the day and ignoring
the month and year, so it's consequently wrong. Any ideas? Help!
thank you
Richard

 

[Rick B]

It would help if you show us what you are putting in the condition field.

 

[Richard T via AccessMonster.com]

Sure...
Essentially it is a horizontal row of textboxes (about 20) and are all
populated with dates, starting with today's then incrementing by one day
right to the end. This is done in the OnLoad event of the form. The
conditions then go like this:
Condition(0): Field value is between [Start] and [Finish] (if true, colour
textbox green and font green)
Condition(1): Field value is not between [Start] and [Finish] (if true,
colour textbox white and font white)
Please let me know if I can clarify further,
Richard

 

[Richard T via AccessMonster.com]

Sorry, just to re-iterate:
the textboxes holding the formatting conditions are unbound and the Start and
Finish controls are bound.
Richard