Center text in a msgbox

[Jessica]

Does anyone know of a way to center the text in a message
box?

I have three lines and I want a return after each line,
but I also want them all centered not left justified.

Thanks!

Jessica

 

[Tim Ferguson]

I have three lines and I want a return after each line,
but I also want them all centered not left justified.

Formatting in a MsgBox is extremely limited. If you want anything, it's
very easy to create your own: start with a small unbound form, put on a cmd
button (to close it with) and a label. The Form_Open event can look at the
OpenArgs method and put the text into its label before it is visible. The
calling code then uses DoCmd.OpenForm with acDialog and the desired text in
the last parameter.

Hope that helps


Tim F