How much can I customise MsgBox Prompts?

[Snuggle Walrus]

Hey all hopefully a quick question and quick answer. I've used plenty of 'yes/no' msg box prompts before but i'm wondering its its possible to change the text of yes/no to give slightly more control over the question i'm asking my user. I want to ask in my message box if the user wants to refund the customer OR add credit to their customer account to use later. My message box buttons if possible would simply read 'refund' or 'credit account' as the two options, I understand this may not be ideal though as there is then no way to escape the message box unless the close button is used?

Thanks!

 

[Gasman]

There was something on here recently about a customised message box/form?

Try searching this site.

 

[CJ_London]

see this link for what you can customise

MsgBox Function - Microsoft Support

support.microsoft.com

I don't believe you can change the button captions, so you would need to create your own modal form

 

[Gasman]

This is the sort of thing I was thinking off, but not the actual one.?
Found via a Google

Create Custom Button Labels for a VBA MsgBox - wellsr.com

As you create new VBA macros and procedures, the MsgBox function is frequently used to communicate, but sometimes the standard MsgBox buttons are inadequate.

wellsr.com

 

[Gasman]

@arnelgp posted this one?

Better Msgbox alternative

before giving this out to the OP, might as well put it here for everyone. the bulk of the code is not mine, just added some good feature.

www.access-programmers.co.uk

 

[Minty]

There is a "better" message box listed here: http://blog.nkadesign.com/microsoft-access/

It's dead easy to use and lets you set up custom button messages.

 

[Gasman]

There is a "better" message box listed here: http://blog.nkadesign.com/microsoft-access/

It's dead easy to use and lets you set up custom button messages.

That was the one I was thinking of

 

[Minty]

That was the one I was thinking of

@Gasman I think the one @arnelgp posted here is a tweaked version of the same.

 

[Uncle Gizmo]

give slightly more control over the question i'm asking my user. I want to ask in my message box if the user wants to refund......

I blogged about the message box awhile back:-

Advanced Message Box - Nifty Access

“Advanced” Message Box Message boxes can be modified quite extensively to give you your user a much better experience. So before you set about creating a Form to use as a Messsage Box, consider using the more advanced features of a "Built In" Message Box. There's a really nicely done example...

www.niftyaccess.com

There's 3 videos giving some in-depth exploration of what you can do. The code is available for download from my download provider. If you want a free copy, let me know and I will send you a Coupon Code..

 

[moke123]

yes its possible with the native messaage box

 

[Snuggle Walrus]

Hey everyone wow thankyou so much for the quick replies! I'm reading through all of them and looking at the examples i'll come back shortly and reply to everyone with how its gone thankyou!