making combobox read only

  • Thread starter Thread starter Silvester
  • Start date Start date
S

Silvester

I have a combobox on my A2000 form that has its rowsource set to a table.

I want to limit users to be able to only select values shown in the combobox
and not allow them to type in any other values.

In other words, how do I make the combobox read-only ??

Thanks !
 
Silvester,

Change the combo's Limit ot List property from No to Yes.

HTH,
Nikos
 
I tried that but it does not achieve what I want done.

I don't want want users to be able to type anything into the combobox. Just
to be able to select an item from the dropdown.

The limit to list allows users to type in the combobox and then throws an
error.

Any other ideas ?
 
I tried that but it does not achieve what I want done.

I don't want want users to be able to type anything into the combobox. Just
to be able to select an item from the dropdown.

The limit to list allows users to type in the combobox and then throws an
error.

Any other ideas ?
Click to expand...

As far as I know, you cannot prevent the user from actually typing in
the box while still allowing a selection from the drop-down.

Here is a modified work-around.

Set the Limit To List to Yes.
Code the Limit To List event:

Response = acDataErrContinue
Exit Sub

The user can type in the box, but nothing will happen (no error
message, no "You have entered ... etc.").
The user can select from the list as normal.

The user cannot exit the control without making a selection from the
drop-down.
 
How about trapping the error in a "Not in List" event?

How about building your own combo box using a text box, list box, and
button?

Good luck.
 
Back
Top