Custom Error Message - for "Required" property

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I'm looking to create a custom error message for
the "required" property of a field in one of my tables.
Is there any way to do this? Thanks.

Eric
 
Use a Validation Rule instead of the Required property.

Set these properties for your field:
Required No
Validation Rule Not Null
Validation Text "You can't leave this blank.'
 
I'm looking to create a custom error message for
the "required" property of a field in one of my tables.
Click to expand...

1) Use a ValidationRule like "IS NOT NULL" and then provide a readable
ValidationRuleText.

2) *And* prevent the users from ever seeing the above by checking the
BeforeUpdate event for the control(s) or the form itself. That way you can
have the form do something intelligent like fill in the value, cancel the
save, or whatever too.

Hope that helps


Tim F
 
Back
Top