Access 2003: populate combobox with CSV values from table column

[Markus]

Hi all

I'm using a continuous form in Access 2003 that is bound to a table
and shows the table records based on some filter criteria. This bound
table has a column 'MyCSV' of type text that contains string values
separated by a semicolon, e.g. 'ABC; 1234; XYZ'. When my form shows
the table records I'd like to have a combobox in each row that is
bound to the 'MyCSV' column of my table and gets filled with the
semicolon-separated values of the respective row. How can I achieve
that? Setting the row source property of the combobox to 'Value List'
and the control source property to 'MyVSV' does not work - in this
case the combobox only shows the entire string as it is in the column,
but does not split it into separate values. Setting the row source
property instead of the control source property does not work as well.


Thanks

 

[Access Developer]

I'm using a continuous form in Access 2003 that is bound to a table
and shows the table records based on some filter criteria. This bound
table has a column 'MyCSV' of type text that contains string values
separated by a semicolon, e.g. 'ABC; 1234; XYZ'.

No, of course those don't work, Access was not designed to handle that type
of data. Normalize your data so that the "myCSV" type of data is in a table
related one to many from your main table.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access

in message