You could include an embedded macro or event procedure (depending on the complexity of the validation) on the BeforeUpdate event on the field where data is entered. It can perform the validation and then pop-up a message using the MsgBox statement depending on the result of the validation. If you don't want to have the update actually complete, just include a Cancel = True statement in the code.