Validation override

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to set up a validation that asks you to double check your
entry without restricting you from entering that data (number field)?
I am currently using excel which allows you to override the validation if
you set it to a warning. I can't seem to find the same feature in access. I
use this when a student correctly answers bonus questions to get a mark above
100%.

Mr. E.
 
Mr. E. said:
Is it possible to set up a validation that asks you to double check
your entry without restricting you from entering that data (number
field)?
I am currently using excel which allows you to override the
validation if you set it to a warning. I can't seem to find the same
feature in access. I use this when a student correctly answers bonus
questions to get a mark above 100%.

Mr. E.
Click to expand...

Instead of a validation rule perform your test in the BeforeUpdate event of the
form.

If (some test) = False
If MsgBox("Are you sure",vbYesNo) = vbNo Then
Cancel = True
End If
End If
 
:

Instead of a validation rule perform your test in the BeforeUpdate event of the
form.

If (some test) = False
If MsgBox("Are you sure",vbYesNo) = vbNo Then
Cancel = True
End If
End If
Click to expand...

Thank you Mr. Brandt. You have been most helpful.

Mr. E.
 
Back
Top