Custom error message on multiple lines

[SteveC24]

Hello,

I don't think this was possible in Access 2000, but I am wondering if it is possible in Access 2003.

I am after making a custom error message, on multiple lines.

You can do it using a macro, but not in VBA (that I can find). The effect I am really after is making the first line bold...for example:

------------------------------
¦ Backend file not found ¦ <<<< IN BOLD
¦ ¦
¦ Contact <blah blah> for ¦ <<<<< In standard print
¦ more information. ¦
------------------------------


Thank you!

 

[SteveC24]

OK - my little picture of my error message didn't come out as well as planned, but you get the general idea!

 

[DBL]

You could make that line the title for the error message so that it appears beside an "!" or something:

MsgBox "Contact blah blah for more information.", vbCritical+ vbOKOnly + vbDefaultButton1, "Backend File Not Found!"

 

[Rich]

Why not just use a pop up form?

 

[SteveC24]

Pop up form....not a bad idea at all!

Thanks!

 

[Mile-O]

I don't think this was possible in Access 2000, but I am wondering if it is possible in Access 2003.

You can do it using a macro, but not in VBA (that I can find). The effect I am really after is making the first line bold...for example:

You can do it an A97 if you want.

With the VBA, you need to use the Eval() function with the MsgBox method.

 

[spacepro]

Have a look at this link

http://www.access-programmers.co.uk/forums/showthread.php?t=61296&highlight=bold+text+msgbox

Oldsoftboss has posted an example in the above thread.

HTH

Andy

 

[ghudson]

You can do it for all versions of Access using the Eval() as Mile-O mentioned. I had posted a sample of the VBA here a couple of months ago...
http://www.access-programmers.co.uk/forums/showthread.php?t=61798

 

[SteveC24]

Thanks everyone! Will use the Eval() as suggested!