Validation text caption

[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)

 

[Jeanette Cunningham]

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

 

[John W. Vinson]

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

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.

 

[Jack Leach]

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)

 

[Jack Leach]

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)