Conditional Formatting

[Guest]

Hello,

In Access 2002, I am using conditional formatting in a Monthly Change Report
to highlight the changed date for the current month, using a date field
(Date/Time data type). Condition 1 is the Field Value is between 6/1/07 and
6/30/07. To supress dates from previous months, as we don't want these to
show on the report, but we also don't want to delete them, I've set Condition
2 as Not Between 6/1/07 and 6/30/07, turn the font color to white. Any
better way to do this?? This is a minor issue, as it is working...

Also, is there a way to highlight the whole record when the date falls into
the current month??

My big issue is that I have a Comments field (Memo data type) that is
related to the date field that I also do not want to show on the report when
the previous months' dates do not show, and I can't seem to find a way to do
this. I've tried looking into the IIF statements, but haven't had any
success. I am NOT an VBA person, and a lot of this stuff you all are talking
about is GREEK to me!! Could anyone help please? Thank you in advance!

 

[Guest]

Why not just filter the report so those dates are not included in the report?
You can do that either in the query that is the record source of the report
or in the OpenReport method.

 

[Guest]

Thanks, Klatuu, good idea! That would solve the problem!

 

[Guest]

Okay what's the easiest way to do that in the query?

 

[Guest]

Okay, I didn't really get an answer here - HELP?! I would like to know:

1 - how to filter the query as Dave mentioned

and 2 - how to also not see the Comment field when on all non-current dates

Thank you!