MsgBox No Default Button - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

MsgBox No Default Button

Scott Axton

5 years ago

OK guys - I hate to admit it but I'm stumped.

In creating a Y/N/Cancel prompt - I know how to adjust which button is the default button. That works great for me every time.

What I can't figure out is how to make NONE of the buttons defaulted. I want to force the user to click the button. Not just press enter to 'click' the button.

Any ideas?

Richard Rost @Reply

5 years ago

That's a good one, Scott. You're not crazy. I don't think it can be done. I ran into this a couple of years ago. What I did was make the Yes/No/Cancel button, default it to CANCEL, and if the user selects cancel, tell them they need to manually click YES or NO. Here's what I did:

    Dim L As Long

    L = vbCancel

    While L = vbCancel

        L = MsgBox("Are you sure?", vbYesNoCancel + vbDefaultButton3)

        If L = vbCancel Then MsgBox "You must select YES or NO"

    Wend

    MsgBox IIf(L = vbYes, "YES", "NO") & " clicked"

Excellent question. I might make this into a TechHelp video. :)

	Richard Rost @Reply 5 years ago
Or, of course, you could make your own popup MsgBox form that has its own rules, kinda like I did in Developer 11.

	Adam Schwanz @Reply 5 years ago
Yea I just spent 30 minutes googling for stuff and none of it works, the only working solution was "build your own"

	Scott Axton OP @Reply 5 years ago
Thanks Richard. I was beginning to doubt myself. Thinking that the simple little task was eating at my brain! LOL.

	Richard Rost @Reply 5 years ago
Don't feel bad. I remember spending a good half hour Googling this too a few years ago. You'd think they would add a `vbDefaultButtonNone` option, but alas. I'll add this to my list of Microsoft Feedback.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View