View Single Post
  #3  
Old May 8th, 2007, 10:25 PM posted to microsoft.public.access.tablesdbdesign
Access Joe
external usenet poster
 
Posts: 118
Default Custom Validation Text message

Would you be able to tell me where and how the code would be written on the
form field?

"Larry Daugherty" wrote:

Tables don't offer much in the way of user interface tools. To do
what you want, do your validation in code at the form level and use a
message box.

HTH
--
-Larry-
--

"Access Joe" wrote in message
...
Hey everyone,

In my table, when a user enters a value that doesn't match my

validation
requirements, it prompts them with an error message. I've

customized the
'Validation Text' field so a custom message comes up.But, is it

possible to
display the "current entry" on this message (the actual entry that

prompted
the error)?

I.E. If a person types the number "200" in a field validated to

only
accepts 100 or less, I would like the mssage to say something like:

"200 does
not fall within the specific range. Please try again."

Any help would be appreciated. Thanks!