Multivalued Field (Access 2007)

Topic

New Reply

When using a multivalued field so the user can make multiple selections how can I have the display value included on my label instead of the bound value?

Also, since I have Access 2003 at work how do I allow a similar multiple selection?

Reply | Quote

Replies

As far as I am aware, Multivalued fields were introduced with Access 2007 and are not available in Access 2003, so you may need to redesign your tables if you want it to work with 2003.

If you know the maximum number of values that will ever be possible (and it’s not too many), you could just add extra columns although you’d also need to add extra selection controls (my old uni lecturers would have a heart attack reading this!). The other way is to create a normalised relationship that involves three different tables all linked together.

You could also create a CSV string from the selection criteria and insert this into a single column. You would obviously need to split this out again when working with the values.

Reply | Quote

As toncc says mutlivalue fields were introduced in Access 2007, and cannot be used with earlier versions.

The best solution is to normalise properly – put one record in a related table for each value.

Another option is to store them in one field, with commas between the values.

This thread has links and demos of how you can do the latter, and have the values from the field displayed in a multiselect list box.

Reply | Quote