readonly comboBox, Access 2002

[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.

 

[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.

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?

 

[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.

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

 

[Ron2006]

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

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.