combo box

[New Ripper]

With a combo box as soon as you click the drop down arrow it displays a box
with 10 rows of records (or whatever you set in the properties).
When I open the form containing the combo box, it displays a single line
till I click the drop down arrow.
How can I open the form and combo box in the state where it dispalys the
number of rows set in the property (as does a list box)?
Am I missing the obvious somewhere!

 

[Dennis]

It can be done, it does not look nice & the combobox must have the focus. In
the Open evebnt of the form, put this code using your comboxname instead.
cmbBox.SetFocus
cmbBox.DropDown

 

[Klatuu]

It would be better to use the Load event than the Open event. Sometimes, all
the object references have not been established in the Open event and an
error can occur.

The Open event can be canceled, so it is best used to determine whether to
continue opening the form or cancel opening the form. The Load event should
be used of this sort of action.

 

[jversiz via AccessMonster.com]

If you use a list box instead of a combo box, you can make it large enough to
display as many records are you want.

Regards,
James C.