How to set Combo default view to custom text?

[Lincoln]

When the form is opened all my combo boxes are blank to start with.

I dont want the default set to blank or any of the combo options once opened. I want to be able to show either COLUMN HEADS or custom text.



Is this possible?

[June7]

If these comboboxes are bound to field of RecordSource, then having the box show anything means value is entered into the field. Is this what you want?

[Lincoln]

no sorry - the comboboxes are linked to the correct source and the correct selection of choices are available.

When I open the form however all the boxes show blank - I want to have titles showing.

[June7]

You can set ColumnHeads property to yes and field names will show in the droplist but not in the box. The only thing that can show in combobox is the value from the bound field or its lookup value. Configure label above combobox to appear as column heads.

If data is not showing in bound combobox when data is in table, something is wrong.

[Lincoln]

So what you are saying it cant be done?

[June7]

As I understand what you want and the nature of comboboxes.

[boblarson]

So what you are saying it cant be done?

As June7 said, you can't do what you want exactly. But you can make it LOOK like you are doing what you want.

1. Place a text box over the top of the combo but not obscuring the arrow for the selecting.

2. Put the words you want into the text box's control source like ="SomethingHere"

3. In the click event of the text box, set focus on the combo and drop down the combo:

Me.ComboNameHere.SetFocus
Me.ComboNameHere.DropDown
Me.txtTextBoxNameHere.Visible = False

4. You will want to set the text box .Visible property to False, also in the click event of the combo box so that if they click the arrow for the combo to drop down, it will also hide the text box.


5. So play with it and see if you can get it working the way you want.