 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008combo box
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! 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 > 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). [quoted text clipped - 3 lines] > number of rows set in the property (as does a list box)? > Am I missing the obvious somewhere! 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.  SignatureDave Hargis, Microsoft Access MVP > 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. [quoted text clipped - 8 lines] > > number of rows set in the property (as does a list box)? > > Am I missing the obvious somewhere! 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. >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). [quoted text clipped - 3 lines] >number of rows set in the property (as does a list box)? >Am I missing the obvious somewhere! SignatureBest Regards, James C. EDI Analyst |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.