Custom Error Message - for "Required" property

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
 
A

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top