Validation Rule requiring Multiple-Entry Verification

[rt0512548]

I want to create a validation rule, or expression, that would require users to simply enter data into a field twice, similar to what you are required to do when registering for an account on the internet (enter a password, then enter it again to make sure that it matches the previous one). This is not to say that I want Access to STORE the data twice, as that would be redundant, but I want the data entry team to have to key in a certain number more than once, to ensure that their first entry matches the second. It's monetary data that I'm trying to protect, and if someone was to accidentally key in $300 instead of $30, the ramifications would not be pleasant. However, the odds of them making the same mistake consecutively are slim. I supposed I could try for three times, but that is overplaying my hand I feel.




Does anyone know how to do this?

[pbaldy]

I would probably use the before update event of the form:

http://www.baldyweb.com/BeforeUpdate.htm