checking to see if a date feild is null

  • Thread starter Thread starter jon
  • Start date Start date
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
 
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...
 
Back
Top