PC Review


Reply
Thread Tools Rate Thread

Custom Validation Text not appearing

 
 
wersh
Guest
Posts: n/a
 
      9th Apr 2009
I created a Validation Text message for a required field, but the default
message appears instead. How do I correct this?
 
Reply With Quote
 
 
 
 
Jeanette Cunningham
Guest
Posts: n/a
 
      9th Apr 2009
Hi wersh,
assuming the validation text is in the table, you can use error trapping to
hide the default message that shows when you are using the form.
That message comes from the form's error event and to trap it, you need to
put code in the form's error event something like this-->

If DataErr = 3314 Then
MsgBox "A value is required. Correct entry or press Esc to cancel."
Response = acDataErrContinue
End If


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"wersh" <(E-Mail Removed)> wrote in message
news:0BE2C79D-BA68-4976-BA9E-(E-Mail Removed)...
>I created a Validation Text message for a required field, but the default
> message appears instead. How do I correct this?



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
custom validation with number & text aditya Microsoft Excel New Users 3 25th May 2009 10:36 PM
custom validation number and text aditya Microsoft Excel Misc 0 25th May 2009 11:17 AM
Validation Text not appearing wersh Microsoft Access 3 10th Apr 2009 03:32 PM
Custom Validation Text message =?Utf-8?B?QWNjZXNzIEpvZQ==?= Microsoft Access Database Table Design 4 9th May 2007 12:09 PM
Text not appearing in a textbox for Outlook 2003 custom form John Riddle Microsoft Outlook Form Programming 12 22nd Jun 2004 02:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:04 AM.