Not accept a value of 0 in a currency field.

[Guest]

In a cost savings field I want to not accept a savings of 0, but a cost of
less than or greater than 0 is acceptable. In my projects database there is
a cost saving field and the engineers are getting around it by putting in a 0
so I want to force them to put in an acceptable value. for example the
savings might be $1.99 or ($1.99) but not $0.00. How can i do that.

 

[Guest]

in the validation rule property of your field put
<>0

 

[George Hepworth]

Add a Validation Rule to that field. Makethe rule <> 0

HTH

George

 

[Guest]

Here is another option if you want to have control over the message box that
displays when the rule is violated. This code would go in the controls After
Update event.


If Me.FieldName = 0 Then
MsgBox "You cannot enter 0 in this field"
Me.FieldName.SetFocus

End If