CF Expression Help

[xmeb]

Hi:

I have searched on Google for what I want to do but I have found nothing that is exactly the same so far.

On a report I have a subreport that has a "PrimiaryLocation" text box. I use the following in the subreport query criteria for my field "DDate" to show primary locations for the last five days which works fine.

>=DateAdd("d",-1,Date())-5

What I would like to do using CF is to have primary locations that match todays date be a different color and those that are two days old be a different color.

Thanks,

xmeb

 

[xmeb]

What is Print Preview mode? I right click the table and select open, is that what you mean? I just created a new blank report and put "DDate" and "PrimaryLocation" text boxes on it and put in the same conditional formatting that is giving us trouble and it still does not work. However, other types of conditional formatting work fine. Thanks.

 

[dhookom]

You can view reports in Design View, Report View, Layout View, and Print Preview.

Can you copy and paste your actual Expression Is in a reply here?

Duane
Hook'D on Access
MS Access MVP

 

[xmeb]

I checked it in Print Preview.

[DDate]>Now()

 

[dhookom]

I'm at a loss. I would need to look at the file.

Duane
Hook'D on Access
MS Access MVP

 

[xmeb]

File is confidential and too big to be stripped and sent. I have been doing research and found that controls and fields cannot have the same names for conditional formatting to work which mine did. I changed them but it still does not work. Thanks for all your help.

 

[dhookom]

Have you tried creating a very small sample database with just the records and report needed to test?

You haven't created a user-defined-function named DDate() have you?

Duane
Hook'D on Access
MS Access MVP

 

[xmeb]

I will create the small database as you suggested tomorrow.

I do not think I have created a user-defined-function named DDate() but I will search for it.

Thanks.

 

[dhookom]

I checked Allen Browne's list of naughty words but didn't see DDATE.

Duane
Hook'D on Access
MS Access MVP

 

[xmeb]

I built a database with a table (two fields), a query, and a report. I used "DDate" and several other field names and it does not work. Other types of conditional formatting work fine.

 

[dhookom]

xmeb,
Is there any way you could post a copy of your file some place we could get it?

Duane
Hook'D on Access
MS Access MVP

 

[xmeb]

Yes, the test one I built I can share. How is that best done? Thanks.

 

[dhookom]

There are a number of file sharing sites like the one mention at the bottom of the reply screen. You can also find my email in the Hook'D on Access web site in my signature.

Duane
Hook'D on Access
MS Access MVP