N nick5196 Registered User. Local time Today, 02:34 Joined Feb 17, 2011 Messages 43 Mar 16, 2011 #1 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 Click to expand... How do i specify if the value = nothing/zero/empty if you see what i mean. Thanks Nick
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 Click to expand... How do i specify if the value = nothing/zero/empty if you see what i mean. Thanks Nick
boblarson Smeghead Local time Today, 02:34 Joined Jan 12, 2001 Messages 32,059 Mar 16, 2011 #2 A good way to handle nulls as well as empty strings is: Code: If Len(Me.Comments & vbNullString) = 0 Then MsgBox "No Comments to show", vbExclamation, "Chichester College" ...etc.
A good way to handle nulls as well as empty strings is: Code: If Len(Me.Comments & vbNullString) = 0 Then MsgBox "No Comments to show", vbExclamation, "Chichester College" ...etc.
N nick5196 Registered User. Local time Today, 02:34 Joined Feb 17, 2011 Messages 43 Mar 16, 2011 #3 thanks a lot
