Conditional Format in a Report

My Report currently has a selection of text boxes, that display the selected option letter, from a list, that's a drop down. What I want to do, is to colour the text box with a RED background if the option is null, and contain a space. Otherwise I need the background white, with the Option letter showing in black, but not highlighted.

I also have a memo box at the end, and wish this to be red, if any of the options, (there are 10 in total) in named boxes called option_a - option_j, are the letter C, and the memo is empty. The option box with the C in also needs to be a red background, with white text, but only if the memo box is empty.


thanks in advance for any help

masterkeys wrote:
My Report currently has a selection of text boxes, that display the
selected option letter, from a list, that's a drop down. What I want
to do, is to colour the text box with a RED background if the option is
null, and contain a space. Otherwise I need the background white, with
the Option letter showing in black, but not highlighted.

I also have a memo box at the end, and wish this to be red, if any of
the options, (there are 10 in total) in named boxes called option_a -
option_j, are the letter C, and the memo is empty. The option box with
the C in also needs to be a red background, with white text, but only if
the memo box is empty.


Well, this is going to be tedious ;-)

I think your question is not stated rigorously, but maybe
this is close to what you need to do.

Select the option_a text box. Then use the Format -
Conditional Formatting menu item to set the Expression Is
option to:

[option_a] Is Null Or [option_a] Like "* *" Or ([txtmemo]
Is NuLL And [option_a] = "C")

and select the desired back color.

Repeat for the other nine text boxes.

To make the memo text box red if it's Null and any of the
options equals C, set the Expression Is to:

[txtmemo] Is NuLL And ([option_a] = "C" Or [option_b] = "C"
Or [option_c] = "C" Or . . . )

--
Marsh
MVP [MS Access]