If Statement...... help with Null value 3

[cranebill]

I am trying to use the following... its pretty cut and dry as to what im trying to accomplish... any one have any ideas to make it work. If i replace Is with = then the output still resorts to the else statement.


If rs1.Email Is Null Then
Forms!Quotes.Email.Visible = False
Else
Forms!Quotes.Email.Visible = True
End If

Any help would be appreciated.

Bill

 

[ChrisCalvert]

I think what you are wanting here is not Is Null, but IsNull. IsNull is a funciton and behaves like so:
(From Access Help)
-----------------------------------------------------
IsNull Function Example

The following example uses the IsNull function to determine whether the value of a control is Null. If it is, a message prompts the user to enter data. If the value is not Null, a message displays the value of the control.

Sub ControlValue(ctlText As Control)
Dim strMsg As String

' Check that control is text box.
If ctlText.ControlType = acTextBox Then
' If value of control is Null, prompt for data.
If IsNull(ctlText.Value) Then
strMsg = "No data in the field '" & ctlText.Name _
& "'." & vbCrLf & "Please enter data for " _
& "this field now."
If MsgBox(strMsg, vbQuestion) = vbOK Then
Exit Sub
End If
' If value is not Null, display value.
Else
MsgBox (ctlText.Value)
End If
End If
End Sub
---------------------------------------

Let me know if this does not help,

Chris

 

[cranebill]

Worked Awesome... Thanx

Bill

 

[psemianonymous]

You might be getting confused because "[fld] IS NULL" is a valid SQL WHERE clause, in MS Access and elsewhere.


Just so you know.
--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access