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

"Jack Leach" <dymondjack at hot mail dot com> wrote in message
news:421DE497-321E-4998-B908-(E-Mail Removed)...
> 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)
>

On Mon, 14 Sep 2009 18:29:02 -0700, Jack Leach <dymondjack at hot mail dot
com> wrote:

>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.
--

John W. Vinson [MVP]

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)



"Jeanette Cunningham" wrote:

> 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
>
> "Jack Leach" <dymondjack at hot mail dot com> wrote in message
> news:421DE497-321E-4998-B908-(E-Mail Removed)...
> > 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)
> >
>
>
>

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)



"John W. Vinson" wrote:

> On Mon, 14 Sep 2009 18:29:02 -0700, Jack Leach <dymondjack at hot mail dot
> com> wrote:
>
> >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.
> --
>
> John W. Vinson [MVP]
>