AddItem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I am trying to add a hidden field to a combo box, and am unable to get more
than 1 field to add/display.

The code is comboboxname.additem (value)

Can anyone tell me how to add the second field?
 
Andre,

You can't use the AddItem method. It's a "feature"!

How you add a column depends on where the combo gets its data from. If it
gets its data from a query, you need to add a column to the query. If it
gets its data directly from a table, you need to use a query to which you've
added an extra column.

If the combo gets its data from the RowSource property (when the
RowSourceType property is set to "Value List"), you need to add the hidden
column to the end of the string in the RowSource property, preceded by a
semi-colon. For example, if the RowSource property is like so:
"ABC"; "DEF"; "GHI"
....then you add the new column like so:
"ABC"; "DEF"; "GHI"; "JKL"

In all cases, you must increment the ColumnCount property to account for the
added column, and add a column width of zero to the ColumnWidths property.
For example, if our ColumnWidths property is like so:
0cm;2.5cm;3cm
....then you add the new column and make it "hidden", like so:
0cm;2.5cm;3cm; 0cm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top