Creating an expression

[Guest]

HI
I want to make an expression that is basically meaning that if the number in
the box is 0 then say that "The animal is no longer on the premisis".

Thanks

 

[Douglas J. Steele]

Where do you want this expression to appear?

To have a message box pop up, you could put code in the text box's
AfterUpdate event:

Private Sub MyTextBox_AfterUpdate()

If Me.MyTextBox = 0 Then
MsgBox "The animal is no longer on the premises"
End If

End Sub

If you're trying to populate another text box on the form, you can set the
text box's ControlSource to

=IIf([MyTextBox] = 0, "The animal is no longer on the premises.", "")

If you're looking for something else, post back with more details.

 

[ion ionescu]

HI
I want to make an expression that is basically meaning that if the number
in
the box is 0 then say that "The animal is no longer on the premisis".

Thanks