macro conditional msgbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The following MsgBox in a macro generates a Yes No condition
MsgBox("Question",36)=7
Can someone tell me what the "36" and "7" do?
 
Z-Man,

The 36 defines the Buttons parameter of the messagebox, in this case
4+32 where 4 is the code for Yes and No buttons, and 32 is the code for
a Question icon.

The 7 is the value returned by the MsgBox function, in this case No.
The code for Yes is 6.

For more details of these numerical codes, see Access Help for MsgBox
function.
 
Back
Top