Conditional formatting of date supplied by a form

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top