Toolbox & Drop Down List Box

[Guest]

Greetings all

Very grateful if anyone has an idea about this one.
On a database form I thought it would be a good idea to use a Drop down List
box. When I opened the toolbox the Icon was not there so using the customise
option I installed the icon. However when I come to use it I get an error
message telling me that the constant that I am using for the control is not
valid - see help. Trouble is I have not done anything yet except click on the
drop down list icon. Also the help menu freezes, I am told that Access has an
error and needs to close down. I send the error message to Microsoft, close
down and restart but the error continues. I have removed the Icon and
re-installed but the error continues. This error occurs with any database I
try.

Grateful for any direction on this

 

[Guest]

Try compiling the Db that may highlight any issue in your code that is
causing the error. Alt & F11 to bring up the VB window then goto "Debug" on
the menu and "Compile".

Regards,
Nick.

 

[Guest]

Should have said hold down the Shift key when starting the Db to prevent any
code firing before you can compile.

Nick.

 

[Van T. Dinh]

To fix up the Toolbar "ToolBox" back to default which should have the
ListBox Control, all you have to do is to use the Menu command
Tools/Customize ... (or right-right in an empty area of the MenuBar or ant
ToolBar and select Customize ...).

 

[Guest]

Greetings and thanks to all who posted a reply.

Thank you all and I have worked around my problem by using the Combo Box
Item. It did produce a Drop Down list box which works.
I believe that the Drop Down List Box Icon does not work. I tried this icon
on three different computers, 2 running Access 2003 and 1 using Office 97.
The same error occured on all three machines. I tried this using an
established database and a new one with no data. Each time the same result.
So to all if you do want a drop Down List Box Controll on a Form use the
Combo Box Icon and select only 1 column. It works.

Regards and thanks again all
--
Enjoy Life and excel in all you do

PJC

To fix up the Toolbar "ToolBox" back to default which should have the
ListBox Control, all you have to do is to use the Menu command
Tools/Customize ... (or right-right in an empty area of the MenuBar or ant
ToolBar and select Customize ...).