combobox height

[scottr]

I am working on an access form. I have a combo box that i am using to get a value from a table and then display the proper name, but i dont want the user to be albe to drop the combo box height down. Is there a way to disable the combobox height?

[Aaron Young]

If you don't want to use to Drop the List, why not use a different control, like a Textbox?

Alternatively you can set the Locked Proerty to true, the USer can srill drop the list, but can't select anything.

Aaron Young
Analyst Programmer
[email protected]
[email protected]

[scottr]

The problem with the textbox is that i have support tables on my database. So lets say you are picking a person, they have a primary key of one, but the column that is displayed would be the actual name of the person.so column one is hidden and column two is displayed but the value is really column one. this is a common thing in access and im not sure how to get the same functionality in a text box.