'Object Required' Error using IF statement

[1no7]

Hi

I keep getting an 'Object Required' error when I use an IF statement to check if a field has a null value.

e.g. If strText.value is null then etc....

I'm using Access97 any ideas?

 

[jgoodman00]

Yes, the syntax is

If IsNull("FieldName&quot Then

James Goodman

http://www.james-goodman.co.uk

 

[thornmastr]

Or,

if nz(strText.value) then Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com