Custom MsgBox Buttons

[Guest]

Is there anyway I can 'customise' the text that appears on a MsgBox. I want
to put my own text on 2 buttons 'Henlow' & 'Corsham' and then run particular
code depending upon which button is selected. I'm OK with putting the code
together, just don't understand how I can get the custom text and subsequent
value to then check against.

Many thanks

 

[Guest]

You cannot do that with a message box. Build a form that looks and behaves
like a message box if you want that capability.

 

[Douglas J. Steele]

Actually, you can. Check my May, 2005 "Access Answers" column in Pinnacle
Publication's "Smart Access" (You can download the column, and sample
database, for free from http://www.accessmvp.com/djsteele/SmartAccess.html)

Having said that, I don't disagree that creating your own form to mimic the
message box is a better solution.

 

[Guest]

Thanks for the info, Douglas. I can't immediately see which article applies,
but I will scan through it.

 

[Douglas J Steele]

It's the May, 2005 column ("I've just got to get a message to you...")