Highlight Null Fields In Datasheet

  • Thread starter Thread starter Steve Wilsen via AccessMonster.com
  • Start date Start date
S

Steve Wilsen via AccessMonster.com

I have a button that when clicked will bring up a query datasheet. I'd
like this datasheet to highlight(red) cells that are missing data (nulls).

Is there a way to do this?

Thanks,
STeve
 
Steve,

If you used a continuous view form instead of a datasheet, you could do
this using Conditional Formatting.
 
Hi Steve,
I changed to the continuous form and I have the following code;

=IIf(IsNull([LOB])," ", [LOB])

1. what's the code to actually hightlight if it's null?
2. how can i check multiple fields for null?

Thanks,
Steve
 
Steve,

I don't understand the purpose of the expression which returns a space
in the case of LOB being null.

In design view of your form, select the textbox on the form which you
want to be coloured if LOB is null. Select Conditional Formatting from
the Format menu. In the Condition combobox, select 'Expression Is', and
then enter:
[LOB] Is Null
.... and set the back color to red. Repeat the process for each such
control.
 
That's exactly what I needed. Thank you Steve!!

Steve Wilsen
 
Back
Top