Can you do this? Yes, but it is not recommended. In a relational database,
each data "point" that you store should be atomic (meaning that it should
not be a combination of things!) -- you can always combine data in displays.
As to how you'd do it with a multi-select listbox, you'd need to write VBA
code that would combine the choices into a single text string and then write
that text string into the field. However, as I state above, I don't believe
you want to do this.
Instead, you should have a separate record for each item that is selected in
the listbox. Although you'll still need VBA code to add each of the choices
to your table, this is the more correct way to store and use data.
--
Ken Snell
<MS ACCESS MVP>
kimc said:
Can multiple pieces of data be stored in a single field? What I'm looking
at, is when using a form, I think I want to use the multi-select feature of
a list box to be able to select more than one of the choices in the list.
The thing is, can I store more than one selected choice in the same field of
a table?
