Not In List Data Additions - Default MSGBox to No?

I have a MSGBox prompt that appears on my form if someone enters text into a
Combo box that's not in that list. The MSGBox basically says "XXX is not in
the list, do you wish to add it?" There's a yes and a no tick box.

The problem is that the Yes option is always highlighted so if the user
presses enter by accident, that entry is added. How do I get the MSGbox to
have No highlighted by default instead of Yes?

Use:
MsgBox("Add it?", vbYesNo+vbDefaultButton2)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Richard Horne" wrote in message
...
I have a MSGBox prompt that appears on my form if someone enters text into
a
Combo box that's not in that list. The MSGBox basically says "XXX is not
in
the list, do you wish to add it?" There's a yes and a no tick box.

The problem is that the Yes option is always highlighted so if the user
presses enter by accident, that entry is added. How do I get the MSGbox to
have No highlighted by default instead of Yes?

Thanks Allen.

That was easy! But I couldn't find that info anywhere.

"Allen Browne" wrote:

Use:
MsgBox("Add it?", vbYesNo+vbDefaultButton2)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Richard Horne" wrote in message
...
I have a MSGBox prompt that appears on my form if someone enters text into
a
Combo box that's not in that list. The MSGBox basically says "XXX is not
in
the list, do you wish to add it?" There's a yes and a no tick box.

The problem is that the Yes option is always highlighted so if the user
presses enter by accident, that entry is added. How do I get the MSGbox to
have No highlighted by default instead of Yes?