Forms

Resolved · Medium Priority · Version 2003

Fri 29 May 2009, 11:31 Delegate Adele said...

Adele has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Forms

Hi,

I have a combi box with 3 columns, and I want those three columns to all display when one record as been selected/highlighted. At the moment, as soon as one record is selected, only the first column displays. How do I ensure that all three columns continue to display on the form for the selected row?

Many Thanks,
Adele.

Mon 1 Jun 2009, 10:02 Trainer Stephen said...

RE: Forms

Hi Adele

Thank you for your question.

The solution is fairly straightforward. You need to set the column count property of the combo box to 3. This will then display 3 columns.

To locate this property, select the combo box in design view, bring up your property sheet and select the data tab. Alternatively you can do it in code with

me.combobox.columncount = 3

You can also set the column heads property to true, and this will display the field name at the top. Finally you can also set the column widths property, for example:-

"3cm;2cm;4cm"

set the above widths to the three columns

Hope this helps

Regards

Stephen

Mon 8 Jun 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.