checking to see if a date feild is null

J

jon

Hi
I am trying to check when a record that loads in to a form to see if a date
field is null but it errors out with a runtime error 424
The code I use is below

Private Sub Form_Load()
If Forms![ICYBaanEntry]![dateIcyBaan] Is Null Then
MsgBox " good"
Else
MsgBox "fail"
End If

the field I am checking will be empty or have a valid date in it.
Any advice would be welcome

Thanks

Jon
 
J

jon

Thanks for that.
now working

Jon


Beetle said:
If IsNull (Forms![ICYBaanEntry]![dateIcyBaan]) Then

etc.


HTH
--
_________

Sean Bailey


jon said:
Hi
I am trying to check when a record that loads in to a form to see if a
date
field is null but it errors out with a runtime error 424
The code I use is below

Private Sub Form_Load()
If Forms![ICYBaanEntry]![dateIcyBaan] Is Null Then
MsgBox " good"
Else
MsgBox "fail"
End If

the field I am checking will be empty or have a valid date in it.
Any advice would be welcome

Thanks

Jon
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA if textbox is null 4
VBA to see if a Section exists in Word Document, and if it does, delete it 2
If statment 2
Updateing a record with a Null value field, fails? 5
Syntax for Is Not Null ? 5
How to return Max date or Null (if there is a Null present) 4
Is Null 2
return null to date field 2

Top