use of ISNULL()

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I am developing a database application using Access 2002.
This is my first attempt at using Access 2002, but I have
extensive experience with Access 97.

I have a form I use to log people onto my application. I
need to check that a field on the form has been completed.
In Access 97 I would just use an if statement like this:

IF(ISNULL(Me!fieldName))then
....
End If

That does not work here. I suspect it has something to do
with references, but am not sure. Please help! If it is a
reference problem, which one would I need?

TIA

Kevin
 
That should work. I useally use:

if IsNull(Me!FieldName) = True then


end if

When you say does not work...do you get a compile error (can you compile
your code?).

However, your syntax should work.
 
Kevin said:
It will not compile. It gives me a syntax error.
Click to expand...

Ah hah!....

This likely sounds like you have a reference problem.

While looking at a code..go tools->references

You will see a "missing" in the list.

For a better expaling of this stuff..check out:
Allen Browne
http://users.bigpond.net.au/abrowne1/ser-38.html

Doug Steele:
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Peter Walker:
http://www.papwalker.com/dllhell/index-page2.html


MsKb Articles: 310803, 208218, 209849, 286300

ACC2000: How Access 2000 Resolves Visual Basic for Applications References
http://support.microsoft.com/default.aspx?scid=kb;en-us;248941

ACC2000: How to Resolve Reference Issues in an Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;310803
 
Back
Top