Null Value Syntax for Conditonal Formatting

[cvegas]

I would like the color of a field to be yellow if there is no data in that
field.

I have tried conditional foramtting but haven't been able to figure out what
to use and the proper syntax.

Use field value is ?
Use Expression is?

Any help would be appreciated.

 

[John Vinson]

I would like the color of a field to be yellow if there is no data in that
field.

I have tried conditional foramtting but haven't been able to figure out what
to use and the proper syntax.

Use field value is ?

IS NULL

as two words.

Use Expression is?

If that doesn't work, use

[fieldname] IS NULL

John W. Vinson

 

[cvegas]

[Field Name] Is Null worked great

Thanks

 

[Ted]

is this supposed to work when the control is a combobox (using a2k)?

[Field Name] Is Null worked great

Thanks

I would like the color of a field to be yellow if there is no data in that
field.

I have tried conditional foramtting but haven't been able to figure out what
to use and the proper syntax.

Use field value is ?
Use Expression is?

Any help would be appreciated.