Highlight Null Fields In Datasheet

  • Thread starter Steve Wilsen via AccessMonster.com
  • 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
 
S

Steve Schapel

Steve,

If you used a continuous view form instead of a datasheet, you could do
this using Conditional Formatting.
 
S

Steve Wilsen via AccessMonster.com

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
 
S

Steve Schapel

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.
 
S

Steve Wilsen via AccessMonster.com

That's exactly what I needed. Thank you Steve!!

Steve Wilsen
 
Top