Msgbox buttons

[citychap26]

Hi All,

Is there a way of asigning anything other that Yes/ No to the keys on a message box?

Cheers

SK

 

[fneily]

The msgbox() takes three parameters. First is your message, then type of message, then box title. The second parameter is where you can change number and type of button, icon style and default button. By adding certain values together, you can create different type of msgboxes. I won't list them here - a book like Access 2000 Bible has the list and examples. When you're in Access, click the Help menu item and search on Msgbox Function Example to see how you code for the user selections in a msgbox.
Or you can just create your own form that looks like a msgbox and does what you want.

 

[Remou]

Late last year ZmrAbdulla posted some code that used hooks (as far as I can remember) that allowed you to change the text on the buttons for a messagebox. Not very helpful, as I can't find it grr.

 

[Remou]

Found it:
Can you change the label of a VBYesNO command button?
thread705-1121429