Validation text caption

  • Thread starter Thread starter Jack Leach
  • Start date Start date
J

Jack Leach

Can we change the Caption of the text message displayed on a failed validation?

The only thing I can get this to say is Microsoft Office Access

thanks...
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)
 
Hi Jack
If you are using a msgbox to display a failed validation, you can use
MsgBox strMsg, ,strTitle
Where you supply a string value for the title.

If that's not the issue, which validation message are you talking about?



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Can we change the Caption of the text message displayed on a failed validation?
Click to expand...

You will get the most flexibility by not using the builtin validation message
at all; instead, do the validation in the Form's BeforeUpdate event and pop up
a Form in dialog view displaying the message. You can set its caption and
appearance however you would like.
 
I had meant the built-in validation message, but John has pointed me in the
right direct.

Thanks.
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)
 
Sorry John... I was trying in BeforeUpdate to format the string, but was
getting "the macro or function in the BeforeUpdate or ValidationRule property
is preventing you from saving data..." error.

I was trying out a validation rule and not even thinking that I should just
do the validation and make the user manually re-enter the phone number by
cancelling the Update rather than attempting to automatically format it.

thanks,


--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)
 
Back
Top