display value in combo box

  • Thread starter Thread starter Kou Vang
  • Start date Start date
K

Kou Vang

I populate a combox1.rowsource = value1. How do I display value1 in the
combo box? I can see it in the dropdown, but how do I display it? Thanks.

Kou
 
I populate a combox1.rowsource = value1. How do I display value1 in the
combo box? I can see it in the dropdown, but how do I display it? Thanks.

Kou
Click to expand...

Setting a Column Width (for any column) to 0" will hide that column.
Make sure the Combo Box Column Width property is correct.
If 1 column is used, then the column width should be 1" (or anything
LARGER than 0"
 
It is an unbound combo box. Is there a way to simulate a click on the combo
box to dispay the list within the combo box? Perhaps this is the way to
display the value in the list?

Kou
 
Kou Vang said:
I populate a combox1.rowsource = value1. How do I display value1 in the
combo box? I can see it in the dropdown, but how do I display it?
Thanks.
Click to expand...


I'm not sure what you mean. If you set the value of the combo box to one of
the values in its list (in the bound column), the combo box will naturally
display that item. So if you set the combo box's RowSource property to,
say, a value list, you can then set its Value property to one of the values
in that list. But I'm not sure if this is what you're trying to do or not.
It would help if you explained in more detail what you want.
 
I populate the combobox from an evaluated expression. It resides in the list
within the combo box. But in the form, the unbound combo box will not
display the value of the list without dropping it down. So...Do I then have
to simulate a click on the arrow of the drop down? Can I use the dropdown
method? In the Access help it clearly states that while in form view, the
combo box will not display anything within its list until the arrow is
pressed and dropped down. So how do I do that without having to manually
click it?

Kou
 
Kou Vang said:
I populate the combobox from an evaluated expression. It resides in the
list
within the combo box.
Click to expand...

People use the word "populate" to mean a variety of things. Are you
actually setting the combo's RowSource property in code, or are you just
setting its value? Would you mind posting your code so I can see what
you're doing?

What are the Column Count and Bound Column properties of the combo box? And
if you're not setting it in code you've posted, what is its RecordSource?
But in the form, the unbound combo box will not
display the value of the list without dropping it down. So...Do I then
have
to simulate a click on the arrow of the drop down? Can I use the dropdown
method? In the Access help it clearly states that while in form view, the
combo box will not display anything within its list until the arrow is
pressed and dropped down.
Click to expand...

That's not right. The combo box won't display *the list* until the combo
box is "dropped down", whether by mouse click, user keystroke, or calling
its Dropdown method. But its value should be displayed as long as it's a
value in the list.

There is a bug introduced with Access 2003 SP3 that apparently leaves combos
looking blank if they're bound to a column with the Format property set --
or something like that, I don't remember exactly. Could you be experiencing
the result of that bug?
 
My column count and bound column are both 1. My row source type is set at
"value list". The rowsource is set to a click within a seperate listbox that
populates it. I also realize, that once I click on the value in the combo
box, and move to the next record, the value is still displayed, even though I
set the rowsource="" when moving to the next record. How do I set the
display="" ?
 
Kou Vang said:
My column count and bound column are both 1. My row source type is set at
"value list". The rowsource is set to a click within a seperate listbox
that
populates it. I also realize, that once I click on the value in the combo
box, and move to the next record, the value is still displayed, even
though I
set the rowsource="" when moving to the next record. How do I set the
display="" ?
Click to expand...


Please post all the relevant code.
 
Back
Top