Share via

Conditional Formatting Errors

Anonymous
2021-12-28T01:03:51+00:00

Hello,

I am trying to setup a conditional formatting for a field on a sub-form to highlight X-BROKEN status in red but it keeps giving me the below error. Please help.

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

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-12-28T21:21:59+00:00

    Yes. It is a lookup field in a table on the sub-form and it is a number. Can I change this to a text? or is the a workaround? Thanks for your advice.

    Hannah

    Was this answer helpful?

    0 comments
  2. George Hepworth 22,855 Reputation points Volunteer Moderator
    2021-12-28T20:25:59+00:00

    Oh, I'll bet Duane's right. If that is a lookup field in the table, and not just in the subform, then it's likely to be bound to a number, not to the text displayed.

    Was this answer helpful?

    0 comments
  3. Duane Hookom 26,825 Reputation points Volunteer Moderator
    2021-12-28T20:01:12+00:00

    It looks like the Status column is a lookup field or possibly a numeric value that references "X-Broken" in another table. Can you clarify if the bound column is numeric?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2021-12-28T18:49:48+00:00

    Good afternoon,

    I changed the field value as you suggested but it still does not return what I formatted. It did not give me the error but still not format to the below input. Thanks for your help.

    Was this answer helpful?

    0 comments
  5. George Hepworth 22,855 Reputation points Volunteer Moderator
    2021-12-28T01:35:01+00:00

    can you show us the actual rule itself? This looks like it needs to be a string delimited with the string delimiter "", i.e. Value = "X-BROKEN"

    Was this answer helpful?

    0 comments