error message

In the table, I set the field required to "Yes". If it
leaves blank, the standard system error message popup. How
could I replace the system error message with my error
message? I tried to put it in the validation text, but it
didn't replaced the system error message.

Thanks
Ashley

Hi Ashley,

You can't. Set the Required Propert to No and use the Validation Rule.
Example:

Validation Rule: Is Not Null
Validation Text: "Hey this is Null"

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "Ashley"
| Sender: "Ashley"
| Subject: error message
| Date: Tue, 10 Aug 2004 06:24:09 -0700
| Lines: 8
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcR+3VGQ5Fg8Qh5qR06EyU9pXrCVKw==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.tablesdbdesign
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:82612
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| In the table, I set the field required to "Yes". If it
| leaves blank, the standard system error message popup. How
| could I replace the system error message with my error
| message? I tried to put it in the validation text, but it
| didn't replaced the system error message.
|
| Thanks
| Ashley
|