Newbie MsgBox question

[Quintios]

How do I get text to center in a message box? I apologize for this really stupid question, but I can't seem to find an answer anywhere, and I know there *has* to be a way to do this.

Here's the box in question:

MsgBox "This action will delete the record" & CHR$(13) & _
CHR$(13) & CHR$(10) & "This action cannot be _
undone.", vbOkOnly, "WARNING!!"

Thanks.
Onwards,

Q-

 

[Craig0201]

Sorry.....there is no way....not with msgbox....

You'll need to create a form as a custom dialog.

Craig

 

[Quintios]

Actually I found a way, you use the VBA command 'String' to add extra spaces to move things over. A bit of trial and error, but it works. So it's not centered in the traditional sense, but it'll work.

Thanks for the feedback!


Onwards,

Q-

 

[bigdars]

The only way I have found is to enter spaces between the first quote and the first character of your text. It takes a little time to figure out exactly how many spaces, but you catch on fairly quick after you have done a few. This will work with your code, but it will not be effective with any dynamicly changing text.