Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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?

  2. #2
    Lounger
    Join Date
    Apr 2002
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    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.
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •