input message box to be check box

[tracktraining]

Hi Everyone,

I have been dealing with input box to be a text box. So the user type in
whatever need to. I have an input box that appears as [trained?
(Y/N/Both)].... but i am wondering if an input message box can appear with
the same message but each of the option has a check box next to it allowing
the user to click the corect option instead of typing out the option. Can
this be done?

Thanks for your help,
Thi

 

[Al Campagna]

tracktraining,
Not using the generic Access Input Box method.
However, you could easily create a small popup form to request the user
to click one of three check boxes... (using an OptionGroup)

Although... an Input box with a prompt like this would be just as
quick...
[Training? (Y=Yes N=No B=Both)]

Depends on whether your users are more "keyboard" oriented vs. "mouse"
oriented.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[fredg]

Hi Everyone,

I have been dealing with input box to be a text box. So the user type in
whatever need to. I have an input box that appears as [trained?
(Y/N/Both)].... but i am wondering if an input message box can appear with
the same message but each of the option has a check box next to it allowing
the user to click the corect option instead of typing out the option. Can
this be done?

Thanks for your help,
Thi

No it can't, using the Access InputBox().
Yes you can using your own unbound form with whatever text or check
box controls and messages you wish.
Add a Command button to the form.
Code it's Click event: Me.Visible = False

Then you would do something like this:

DoCmd.OpenForm "YourFormName" , , , , , acDialog
If forms!YourFormName!ControlName = True then
' the check box was checked. Do something
Else
' the check box was not checked. Do something else
End If
DoCmd.Close acForm, "YourFormName"