If IsNull 1

[lars7]

Hi,
Could anyone tell me why this isn't working but if I change it to "If Not IsNull" and select the list boxes it does.

If IsNull(Me!List7 & Me!List8) Then
Beep
MsgBox "Please select a manager and date for the report.", vbExclamation, "Required selection"
Exit Sub
End If

thanks.

 

[lars7]

It's working fine with date fields but not with text.

 

[lars7]

Hi,
I worked it out myself thanks. Can I give myself a star?

If (Me!List10) = "" Then
Beep
MsgBox "Please select a location for the report.", vbExclamation, "Required selection"
Exit Sub
End If

 

[MajP]

Lars,
Often you will see on this site the following

if trim(cntrlName & " ") = "" then ...

The versatility of the above is that it catches
a null
a hard space
and an empty string

 

[lars7]

Thanks Majp,
I will use your's from now on.