Share via

M/S Access Reports Conditional Formatting Help needed

Anonymous
2019-04-08T06:49:00+00:00

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

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-04-13T07:26:55+00:00

    Good morning Ken,

    Apologies for the small images, not sure why that happened.

    I'm re-attaching them again.

    I will review your response as well ;)

    Tom Petrik

    0 comments
  2. Anonymous
    2019-04-13T10:27:41+00:00

    Something weird has happened with the image I posted.  It shows  Len[Cap received] _ "") = 0, whereas it should be Len[Cap received] & "") = 0.  It was correct in my test form, which did exactly as expected.

    As regards the parameter prompt, it suggests that there is not a control named CAP received in the form.

    0 comments