"Markus" <(E-Mail Removed)> wrote
> 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
news:12085357-0a3b-4b2f-8c61-(E-Mail Removed)...
> Hi all
>
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
|
Similar Threads
