Validate a field

[tweety]

any ideas how to validate a postcode\zip code use vba anyone? currently iam using the in-built input mask >LA99\ 0LL;0;_



thanks

[tweety]

Iam using this code to validate if a price is bewteen 1 and 9, it works fine but its not displaying the right error message. is not showing the one below, its showing the access one with the help button

Private Sub Form_BeforeUpdate(Cancel As Integer)
If txtBuyingPrice <= 0 And txtBuyingPrice >= 9 Then
Cancel = True
MsgBox "Please enter a valid buying price", vbCritical + vbOKOnly
Me.txtBuyingPrice.SetFocus
Exit Sub
End If
End Sub


Please advice, Thanks

[tweety]

can any help with validating the above numbers please? thanks

[RuralGuy]

What have you tried and how did it work?

[June7]

Is anything in the Validation Rule property? Remove it.

Is 9 a valid entry?

Did you resolve the zip/postcode validation.