What to write in format options in query to display between numbers and color field in Access

Ahmad Arief Mohd Nor 196 Reputation points
2021-08-09T03:50:32.71+00:00

for now i have done "[Green]0.00 ;[Red]-0.00;[Blue]0;[Cyan]"Nothing Entered" in the format options in query. But anyone can correct my condition instead of [positive, negative, zero, none entered] i want to test for <>. If i write the format like this

"[Green] >3 ;[Red]<3 ;[Blue]0;[Cyan]"Nothing Entered"

It just display >3 or <3 next to the current value in my table.

I would also like ask if it is possible to color the cell background instead of only the text using the format options. Thank you.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
833 questions
0 comments No comments
{count} votes

Accepted answer
  1. Gustav 712 Reputation points MVP
    2021-08-09T09:18:58.577+00:00

    That is not possible. The sections are for positive, negative, zero, and Null values

    To format for different values, apply Conditional Formatting in the form you use to display the values.

    0 comments No comments

0 additional answers

Sort by: Most helpful