Specifying value of zero (1 Viewer)

[nick5196]

Hi,
very simple. I have this code

If Me.comments.Value = "" Then
MsgBox "No Comments to show", vbExclamation, "Chichester College"
End
Else
Me.Refresh
DoCmd.OpenReport "rptIndividualStudentComment", acViewReport, "", "", acNormal

How do i specify if the value = nothing/zero/empty if you see what i mean.
Thanks
Nick

 

[boblarson]

A good way to handle nulls as well as empty strings is:

If Len(Me.Comments & vbNullString) = 0 Then
  MsgBox "No Comments to show", vbExclamation, "Chichester College"
 
...etc.

 

[nick5196]

thanks a lot