Conditional Formatting with Dates

  • Thread starter Thread starter Richard T via AccessMonster.com
  • Start date Start date
R

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
 
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
 
Sorry, just to re-iterate:
the textboxes holding the formatting conditions are unbound and the Start and
Finish controls are bound.
Richard
 
Back
Top