Need Help with conditional formatting question

[TNich]

Needing a little help and one of my friends suggested that I try here. I've been tasked with a project for tracking contractos and visitors to my base using access. My supervisor wants the expiration dates of their visit to turn red to indicate that the project or their visitation privileges have expired. I know that it involves conditional formatting and an expression but I'm not sure how to make it work. Any help anyone could give would be greatly appreciated. Thanks.

[pbaldy]

An expression like:

[ExpirationDate] <= Date()

[TNich]

An expression like:

[ExpirationDate] <= Date()

Ok, I'm doing that and I get a message that pops up on screen asking for the parameter value. Then when I click on my table I can get things to change to red but it also makes them disappear is there something I need to tweak in this expression that will make it not do that? I don't want it to turn red until it expires and I don't want it to disappear from the form.

[TNich]

I should say it asks for the expiration date when I open the report. I tried inserting the value in the form and the report. because I want it to show up red on the report on the day of expiration.

[pbaldy]

Is that field on the report? Can you post the db here?

[TNich]

Is that field on the report? Can you post the db here?

I do have that field on the report. It pulls the info from the form. With the information that has already been entered I don't think I can post the DB here because of security concerns with protected privacy info.

[pbaldy]

We certainly don't want private information posted, but it's getting hard to debug. The parameter prompt is Access telling you it can't find something. Make sure the field is spelled exactly like in the report's source. There may need to be a textbox on the report bound to the field, though it can be hidden.

[TNich]

Ok, took me a while but I cleared the data from it. How to I post it here for you to look at? I am at a stand still with this and really need help to finish. Guess I should take a course at the local college on programming.

[pbaldy]

Do a compact/repair, then zip. Then in the advanced reply area you'll see a Manage Attachments button.

[TNich]

TEST TEST TEST Contractor-Visitor Management.zip

Here it is

[pbaldy]

I don't get any prompts, though with no data it will be hard to test the conditional formatting. Where exactly am I looking?