I have a table displayed on a form in the details section (not in a subform) and one of the columns is CallBackDate which is stored as a date field and displayed as "dd/mm/yyyy" when i do conditional formating on it so that fieldvalue of CallBackDate < or= todays date it compares the CallBackDate as a text field. thus if todays date is 31/12/2012 then any callbackdate which starts with a day less than 31 formats with a green background. Here is the conditional format i have
Value=Format(Date(),"dd/mm/yyyy")
.
Value=Format(Date(),"dd/mm/yyyy")
.
