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
Syntax for Is Not Null ? 5
Is Null 2
Updateing a record with a Null value field, fails? 5
If is null 1
insert null date/time 11
Invalid use of Null 15
return null to date field 2

Top