help with value of a control 1

[ProgramError]

Dim ctrl As Control
For Each ctrl In Me.Form
If ctrl.ControlType = acTextBox Then
If [purple]ctrl.value[/purple] = Null Then Debug.Print "NULL NULL NULL"
end if
next

Help wanted to check the value of the control for null. Need syntax for purple words above.

Thanks

Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.

 

[Crowley16]

if control is null

or

nz(control, "alternateValue")

--------------------
Procrastinate Now!

 

[PHV]

For Each ctrl In Me.Controls
If ctrl.ControlType = acTextBox Then
If IsNull(ctrl.Value) Then
Debug.Print ctrl.Name, " NULL NULL NULL"
End If
End If
Next

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ZmrAbdulla]

    Dim ctrl As Control
    For Each ctrl In Me.Form
        If ctrl.ControlType = acTextBox Then
           [b] If IsNull(ctrl)[/b] Then Debug.Print "NULL NULL NULL"
        End If
    Next

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[ProgramError]

FOUND IT!!!

It was ...
If IsNull(ctrl) Then Debug.Print "NULL NULL NULL"

Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.

 

[ProgramError]

Hi ZmrAbdulla

I Must have been entering my reply while you where posting yours. Have a star for the right answer anyway.

Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.

 

[PHV]

Ian, why are you implicitly saying that my answer wasn't right ?