Check for Null In Conditional Formating

[Allen Browne]

Try the expression:
IsNull([NameOfYourFieldHere])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
Reply to the newsgroup. (Email address has spurious "_SpamTrap")

"Chaster" <csanto@chadeen.com> wrote in message
news:%hYVa.46806$zy.43968@fed1read06...

> I have had no luck with trying to figure out the syntax to determine if a
> value is null
>
> I have tried fieldvaule = "IsNull" but it only fires the condition if the
> text in the field = IsNull
> I have tried expression value ="IsNull"
>
> If you can help me out with this I need to check several types of field
> values such as Dates, Times and Text.

[Emilia Maxim]

"Chaster" <csanto@chadeen.com> wrote:

>I have had no luck with trying to figure out the syntax to determine if a
>value is null
>
>I have tried fieldvaule = "IsNull" but it only fires the condition if the
>text in the field = IsNull
>I have tried expression value ="IsNull"
>
>If you can help me out with this I need to check several types of field
>values such as Dates, Times and Text.

Chaster,

if you want to use IsNull in code, then you must write:

If IsNull(ControlName) Then...

The data type is not relevant.

See also Help on IsNull function - which you should have done in the
first place, there are even examples.

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
[url]http://www.maxim-software-service.de[/url]