Dropdown List Error

[Guest]

Hello!

Within the 'Form - Design View', I placed the 'Dropdown List' button from
the 'Tools - Customize' menu. After doing so, I clicked on the newly placed
'Dropdown List' button to create a dropdown list.

However, as soon as I clicked the button, an error popped up, displaying the
following message:

"The constant you entered for the control type is invalid. For a list of
valid constants you can use to create a control, click Help."

Unfortunately, when I click 'Help', Access opens a window with nothing in
it. Then, when I click 'OK' to try and exit the error message, it simply
pops us again... In short, the program freezes!

What's going on? How do I make a dropdown list box?

Thanks for your help!

Sincerely,
Clinton

 

[Wayne Morgan]

Tools|Customize is used to customize the toolbar, not to place items on the
form. To place a drop down list on the form you need to use the toolbox.
With the form open in design mode, go to View|Toolbox to make the toolbox
visible (if it isn't already). Run the mouse over the icons on the toolbox,
pausing at each momentarily to see the tool tip that pops up. The control
you're looking for is called a combo box.

 

[Dave]

I think this control can only be used on data access pages and will
force a three finger salute (shut down of the program)if you try to use
it on a form or report. Use a regular combo box or list control. Check
out http://www.kbalertz.com/kb_Q283208.aspx

 

[Dave]

Wayne, at first I was going to reply much the same as you did, but
since it's not possible to add a control to a form in that manner, I
figured Clinton probably just didn't say it quite right. I think he
means he added the control to his toolbox by using Tools>Customize,
then tried to add the control to his form from his customized toolbox.
Clinton, did you Google your error message (or part of it)? That's how
I solve many program problems when the Help file is anything but, and
it's how I found the link I put in my first reply. Works for me!

 

[ezadin]

Tools|Customize is used to customize the toolbar, not to place items on the
form. To place a drop down list on the form you need to use the toolbox.
With the form open in design mode, go to View|Toolbox to make the toolbox
visible (if it isn't already). Run the mouse over the icons on the toolbox,
pausing at each momentarily to see the tool tip that pops up. The control
you're looking for is called a combo box.