Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Custom Message for Required Fields. 4

Status
Not open for further replies.

InfoNow

IS-IT--Management
Apr 20, 2001
106
US
I have a field called Description in a table. It is set as required. When a user leave this field blank in a form, a message stating that is field cannot be null pops up.
What I would like is to customize this message. Is there any way to do this?

TIA
 
Rick

I'm back!

This is working great, but my users can't use my UNDO button. Seems that as long as there's a control with the "validate" tag, there's no way out of the form without inputting anything!

What can I do? I'm lost with this. Thanks!

Jim DeGeorge [wavey]
 
Rick

Solved it! I put your code in an if statement:

If Me.Dirty Then

YOUR CODE

ENDIF

My closing code.

This worked great. I tried to give you another star. Don't know if you can get more than one star from the same person, but I tried. Thanks!

Jim DeGeorge [wavey]
 
That was the reason why I attached it to the Save button (it was an automatic Undo until all the fields were filled in).....Glad you found a work around

Rick
 
My users hate too many keystrokes, so to have an ADD button and a CLOSE button was just too much for them. Go figure!

Thanks again!

Jim DeGeorge [wavey]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top