MsgBox, VBA, custom

[redFred]

Access novice here...can someone show me (if there is a simple way) to create
a message box such as vbYesNoCancel wherein I can change the text to read
something else? I am able to use the standard vbMessages, but want more.

I want my user to select either item 1 or item 2 or item 3 and and the
attached code will respond accordingly.

Thanks in advance for any help.

 

[Roger Converse]

I am not sure if there is a better way, but in the past, I have created an
InputBox for such cases. I typically give the choices and explanations in
the text portion of the InputBox. Then the user can enter the option that
they want and you can add as many options as you'd like.

For example:

strResponse = InputBox("Enter A to create Report A" & vbcrlf & "Enter 'B'
to run report B.....", vbokOnly, msglbl)

Thanks,
Roger

 

[Albert D. Kallal]

It usually better to just create a small custom form that looks much like
the dialog, and then you can place/change it to whatever you want....


There is a bit of trickery to get the code to "halt" like a regular dialog
box, but I show how to do that here:

http://www.members.shaw.ca/AlbertKallal/Dialog/Index.html

 

[redFred]

Thanks to you both for replying. Albert, looks like what you suggest is
going to work nicely. Thanks.