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

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Thomas Woof" <(E-Mail Removed)> wrote in message
news:2083BFFE-6F73-4B0C-A00A-(E-Mail Removed)...
> 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
>

"Thomas Woof" <(E-Mail Removed)> schrieb im Newsbeitrag
news:2083BFFE-6F73-4B0C-A00A-(E-Mail Removed)...
> 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
>