Load Combo box

T

Trever B

I would like to load a combo box with words from a string.

For example Info = "The quick brown fox jumped over the lazy dog"

Combo Box =

The
quick
brown
fox
jumped
over
the
laxy
dog

I think you use the function split but not sure how to.

Access NT in use

Thanks in advance
 
D

Duane Hookom

You could try something like:
Me.cboYourCombo.RowSource = Replace(Info," ",",")
 
D

Dirk Goldgar

Trever B said:
I would like to load a combo box with words from a string.

For example Info = "The quick brown fox jumped over the lazy dog"

Combo Box =

The
quick
brown
fox
jumped
over
the
laxy
dog

I think you use the function split but not sure how to.
Click to expand...

If the words are all separated by a single space, and the semicolon
character is not in the string, you can do it easily without even using
the Split function; e.g., :

Combo0.RowSource = Replace(Info, " ", ";")

Without the stipulations I mentioned above, though, it would be a little
bit more complicated.
Access NT in use
Click to expand...

I wonder what that is.
 
Top