Custom Error Message - for "Required" property

[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

 

[Allen Browne]

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.'

 

[Tim Ferguson]

I'm looking to create a custom error message for
the "required" property of a field in one of my tables.

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