Message box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John.bb - 24 Nov 2005 16:22 GMT

I have been using the following code to prompt a message when data in a text
box changes to a particular value.
If Me.TheTextBox = "Particular Value" Then
MsgBox "Out Of Specification"
End If
This works fine when the value is text. However I cannot get it to work on
numerical values e.g.
If Me.TheTextBox >100 Then
MsgBox "Out Of Specification"
End If
What am I doing wrong?

Reply to this Message

Rick Brandt - 24 Nov 2005 16:30 GMT

> I have been using the following code to prompt a message when data in
> a text box changes to a particular value.
[quoted text clipped - 7 lines]
> End If
> What am I doing wrong?

Try...

If Val(Me.TheTextBox) >100 Then
MsgBox "Out Of Specification"
End If

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message