check for empty/NULL value in controls

[jguscs]

I've got a recordsource that feeds the value of the control AddDate in a report.
The recordsource is blank/empty/uninitialized/NULL.
I want the result of the code below to spit out a pop-up message box that says EMPTY! but it doesn't work.
The code is in the Detail_Format section of the report.
Any ideas?

If IsEmpty(Me.AddDate) Then
MsgBox "EMPTY!"
End If

 

[IMO]

This may work...

If Me.AddDate = "" Then 
MsgBox "EMPTY!" 
End If

IMO

 

[jguscs]

it didn't:
Error 2427
You entered an expression that has no value.
and points to the line:
If Me.AddDate = "" Then

 

[IMO]

Private Sub YourReport_Activate()
If IsNull(Me.AddDate) Then
MsgBox "EMPTY!" 
End If
End Sub

IMO

 

[Rich]

Please stick to one post on the subject
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=52219

 

[jguscs]

OK.
For anyone who searches for info in this post and wants the answer,...

Use the IsDate function.