Shaded in Field

[CodeCracker0291]

We are sending out "member information" and would like the field area to shade yellow if there is no information in it. How would I go about doing it. I've tried the conditionaly formatting but I don't know how to tell if that if it is empty to shade yellow. THanks
-Jerad

 

[WayneRyan]

Jerad,

Use Conditional Formatting:

Left pane = Expression Is
Right pane = IsNull([ThatField])

Wayne

 

[CodeCracker0291]

Sorry, when i put [ThatField] when i try and run it, it ask me for a value. Am I suppose to replace something? If so, what?

Thanks.
-Jerad

 

[WayneRyan]

Jerad,

Yup,

In my example, [ThatField] is the name of the field you want to Conditionally
format.

Get the report in Design View,
Select your desired field,
Go to Conditional formatting,

Do the "Expression Is" part,
Substitute the name of your field in the IsNull on the right-hand pane.

Wayne