Conditional formatting of date supplied by a form

  • Thread starter Thread starter tc2004
  • Start date Start date
T

tc2004

I have a form [frm_DateRange] that supplies a date [DateAfter] to a query and
a report based on the query.

On the report I would like to conditionally format a date based on whether
it is before or after [DateAfter], but it does not seem to work.

I have set the conditional format to bold for :
Field Value Is Greater Than [Forms]![frm_DateRange]![DateAfter]

If I enter the date on the form as 1/1/09 all dates on the report turn bold.
(There are dates both before and after 1/1/09 in the list.)
If I enter it as 1/1/2009 all but one date (the date is 1/1/2007) turn bold.

What is going on and how do I fix it? Does Access not recognize the input as
a date?

Thanks.
 
Back
Top