Conditional Format in a Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

masterkeys - 02 Dec 2005 14:54 GMT

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

Signature

masterkeys

Reply to this Message

Marshall Barton - 05 Dec 2005 04:39 GMT

>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
[quoted text clipped - 7 lines]
>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 . . . )

Signature

Marsh
MVP [MS Access]

Reply to this Message