By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,279 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Conditional Formatting on ACCESS reports

P: 3
I've used conditional formatting on ACCESS reports but have come up with a problem using it for a FIELD that has a value of either YES or blank/null.

The default formatting (used when condition(s) are not met) is always used EVEN WHEN I specify Condition 1 to change the formatting when the field is YES.

What am I missing....doesn't conditional formatting work on fields defined as TEXT with values of YES or Blank(Null)?
May 17 '07 #1
Share this Question
Share on Google+
6 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
This thread is being moved to the Access forum.

ADMIN
May 17 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
What expression exactly are you using in the condition of the Conditional forumatting.
May 17 '07 #3

P: 3
GAC
What expression exactly are you using in the condition of the Conditional forumatting.
The DEFAULT option is for no background color.If (Field Name) condition is not equal to YES the background color is supposed to be changed. When I run the report there is NO background COLOR.....period - no matter if the value is YES or blank.

IF, however, I change the value in the Query for the field used in the conditional formatting on the report to a numeric value, THEN the background color appears. That's why I'm wondering if conditional formatting works on alphanumeric values or just numeric values.
May 17 '07 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
The DEFAULT option is for no background color.If (Field Name) condition is not equal to YES the background color is supposed to be changed. When I run the report there is NO background COLOR.....period - no matter if the value is YES or blank.

IF, however, I change the value in the Query for the field used in the conditional formatting on the report to a numeric value, THEN the background color appears. That's why I'm wondering if conditional formatting works on alphanumeric values or just numeric values.
Did you enclose the Yes in quotes
May 17 '07 #5

P: 3
GAC
Did you enclose the Yes in quotes
Nope! I tried it and that was the missing element. Thanks.
May 17 '07 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
Nope! I tried it and that was the missing element. Thanks.
No problem.

Always enlcose strings with quotes and dates with #
May 18 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.