Validation Rule

[accessman2]

Hi,

I have one field which set the validation Rule.

Validation Rule: >0

So, the value must be greater than 0.

I enter 5, then go to next field, and then go back to change 5 to Null (blank). Then the error message come out.

I want to allow the blank in the field after I change the value.

-------------------------------------------------------------------------

I tried to use another way:
Private Sub Invnum_AfterUpdate()

If ([Invnum] <= 0) Then
MsgBox "The value must be greater than zero.", vbInformation, "Message"
[Invnum].setforce
End If
End Sub

But, it doesn't work very well, because the setforce cannot go back to the [Invnum] field. And, if close the form, it cannot hold it.

How can I control it?

Please let me know, thanks.

 

[wazz]

make the validation rule: Is Null Or >0

and put your error message in the Validation Text property.