question

AhmadAriefMohdNor-2381 avatar image
0 Votes"
AhmadAriefMohdNor-2381 asked gustav answered

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

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.

office-access-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

gustav avatar image
0 Votes"
gustav answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.