rowsource formatting

[Ethereal]

I know that for 1 column in a combo box you can say cboBox = a;b;c;d;e;f; But for my situation i need to have multiple columns... Does anybody know what the string should look like for multiple columns of values ?

 

[reclusivemonkey]

Nope, but you can base it on a table/query if this helps.

 

[Ethereal]

well i would, but i am browsing for files, I need the full filepath in my table, but only the filename to appear in the box for selection

 

[john471]

Set the column count property for the combobox to the number of columns you require, then format the string as normal.

e.g. clumn count = 2
RowSource= "a";"dog";"b";"cat";"c";"goat";"d";"sheep"

gives combo with

a | dog
b | cat
c | goat
d | sheep

Is that what you meant ?

HTH

Regards

John

 

[Ethereal]

yes that's exactly what i meant!