readonly comboBox, Access 2002

B

bg_ie

Hi,

How do I make a comboBox read only so that the user can only select
from the list and not enter any data?

I'm working with Access 2002,

Also, is it possible to have a form where new rows can't be added?

Thanks for your help,

Barry.
 
B

bg_ie

Hi,

How do I make a comboBox read only so that the user can only select
from the list and not enter any data?

I'm working with Access 2002,

Also, is it possible to have a form where new rows can't be added?

Thanks for your help,

Barry.
Click to expand...

Maybe its possible to handle the ON Key Press event so that it can
ignore any text that is entered into the combo's text box? What do you
think?
 
K

Kjell Harnesk

Hi,

How do I make a comboBox read only so that the user can only select
from the list and not enter any data?

I'm working with Access 2002,

Also, is it possible to have a form where new rows can't be added?

Thanks for your help,

Barry.
Click to expand...

Both things can be set easily, check the properties for the combobox and
the form.
 
R

Ron2006

Both things can be set easily, check the properties for the combobox and
the form.
Click to expand...

One of the properties of the combo box on the data tab is "Limit to
List" - set it to YES

One of the properties of the entire form on the data tab is "Allow
Additions" - set it to NO.
 
Top