M/S Access Reports Conditional Formatting Help needed

Question

Hi there,

I generate a weekly report in my job in Microsoft Access.

What I would like to is to HIGHLIGHT in RED whenever the Due Date is 7 days within the Due Date.

I have tried all kinds of things, but can't seem to get it to work.

I can get the "text verbiage" to the left of the date to HIGHLIGHT, but NOT the Due Date for some reason.

Any help is appreciated.

Thank you,

Tom Petrik

Answer 1

Under conditional formatting you need to choose 'expression' and have something like [txtYourFieldName]<Date()+7

Answer 2

Do you mean that the current date is seven or less days before the Due Date?  If so then conditionally format the Due Date control with:

    Field value is    between    Date()-7    and  Date()

You might also want to format it to show overdue rows in a different colour with:

    Field value is    greater than    Date()

Answer 3

Hi Ken,

Thank you for your reply.

I followed your example, and it seems to work I think.

With the expression you provided above i.e. Date()-7 and Date() I noticed that my Due Date of 4/15/19 did NOT highlight.

I'm trying to use the "Due Date" field with Conditional Formatting to show when we're within 7 days of it being due, i.e. 4/8/19 in the example of 4/15/19 it should highlight it say "RED".

For some reason it's not working.

However, I DID notice that for any dates BEFORE Date() which I presume is the current date it DID highlight them.

Hopefully I'm stating it correctly.

Thank you respectively,

Tomas Petrik

Answer 4

As per previous post, choose 'expression is' from the conditional formatting drop down, and add your expression. To highlight jobs due within the next 7 days it would be something like [duedate]<date() and [duedate] >date()-7. You need to modify it to what YOU want.... maybe =>date

Answer 5

Sorry, should be date()+7 and not date()-7