Using AddItem On Combobox and list box

[Roy Goldhammer]

Hello there

I've foud out that on access 2003 as diffrent from access 2000 i can use
AddItem Method like VB to add new item to listbox or combobox.

It works fine when the the column count is 1 but it doesn't shows anything
when i'm using muli colums. (most of my comboboxes are like this)

is there another way to use AddItem Method?

--
øåòé âåìãäîø
ù.î. òúéã äðãñú úåëðä
(e-mail address removed)
èì: 03-5611606
ôìà' 050-7709399

 

[rkc]

Hello there

I've foud out that on access 2003 as diffrent from access 2000 i can use
AddItem Method like VB to add new item to listbox or combobox.

It works fine when the the column count is 1 but it doesn't shows anything
when i'm using muli colums. (most of my comboboxes are like this)

Column count = 2

..AddItem "Rolling Stones; Back Of My Hand"

result:

Rolling Stones | Back Of My Hand

Strings that contain commas or semi-colons must be delimited by
quotes

..AddItem "Rolling Stones;" & _
Chr$(34)& "Good Times, Bad Times" & Chr$(34)

result:

Rolling Stones | Good Times, Bad Times