I know there are 3 styles of comboboxes. I just need to know how to set it
to the style I want. If anyone knows the coding to put in vba or the steps
to take in design view, it would be greatly appreciated.

"mb" wrote:

No. I want to display a combo box that show all the values in the list and
allows users to type in values that are not in the list in the textbox of the
combobox. What I've read so far is this:

There are three combo box styles. Each style can be set at design time and
uses values, or equivalent Visual Basic constants, to set the style of the
combo box.

Style Value Constant
Drop-down combo box 0 vbComboDropDown
Simple combo box 1 vbComboSimple
Drop-down list box 2 vbComboDropDownList


"fredg" wrote:

On Thu, 30 Oct 2008 11:58:01 -0700, mb wrote:

How do I go about changing the style of a combobox in Access 2000 from the
default to a simple combobox (i.e. show records in list at all times instead
only showing records when arrow is clicked?)? I've seen articles on the 3
styles available, but none with an explanation on how to actually set it to
the simple style.

The 'style' of a combo box?
A combo box is a combo box.

If you are looking to display the values at all times, then you want
to use a LIST BOX.

In Design view, right click on the combo box and select Change to List
box.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail