Format MsgBox Text

[greggranger]

Does anyone know how to format the Text inside of a message box? I'd like the second line of text to be centered

MsgBox("You are about to delete Claims Transaction Summary Report records"&Chr(13)&Chr(13)&"Click Yes to continue", vbYesNo, "Delete Claims Transaction Summary Report records?")

Any help is appreciated

 

[lupins46]

THere are no formatting features of this type for a msgbox.

You will have to do it yourself using spaces or else design your own message box form.

 

[greggranger]

Thanks for the response....seems like it best to design my own.

 

[ESquared]

There is more formatting available in message boxes than many people know. It's not customizable, but perhaps what's already there could be suitable for someone's needs:

You can use the MsgBox action to create a formatted error message similar to built-in error messages displayed by Access. The MsgBox action(function) permits you to supply a message in three sections for the Message argument. You separate the sections with the "@" character.

The following example displays a formatted message box with a sectioned message. The first section of text in the message is displayed as a bold heading. The second section is displayed as plain text beneath that heading. The third section is displayed as plain text beneath the second section, with a blank line between them.

Enter the following in the Message argument:

Wrong button!@This button doesn't work.@Try another.

 

[mp9]

ESquared is right but this is buggy at best, especially if used within VBA - there, it hasn't worked properly since the good old days of Access 97. Help is at hand though: see

http://www.mvps.org/access/bugs/bugs0035.htm

for a workaround.

http://www22.brinkster.com/accessory/

 

[mp9]

Also, see this thread for the centering:

http://www.tek-tips.com/viewthread.cfm?qid=435428

http://www22.brinkster.com/accessory/