Validating a field in a form

[354688]

How do I validate a field in a form, that contains five characters, to see if the last character entered is an "i" . If this condition is true then I wish to skip the next field and enter date into the next field afterwards.

 

[EnidtheDog]

You could probably use an Input mask and Validation, but I prefer to use the Before Update event 'cos it gives more control...eg:

If Not Right(Me![Text1], 5) = "I" Then
MsgBox "Put the right information in you dozy $%^&!"
DoCmd.CancelEvent
End If