inserting all listbox items into a single field in access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Jenny007
    New Member
    • Jun 2015
    • 1

    #1

    inserting all listbox items into a single field in access

    The project that I'm working needs me to be able to insert all of the listboxs items into an order field in access. And between each item a ','(comma) must be inserted as well.
    Googling this has not been much help

    Is there a way that this will work?
    Thankyouuu
  • Seth Schrock
    Recognized Expert Specialist
    • Dec 2010
    • 2965

    #2
    Is this list box using a table/query for its row source, or is it a value list? Either way, you will have to create a loop that concatenates all the values together with the comma in between. The difference is what you end up looping through.

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32669

      #3
      It certainly can work Jenny. You'll need to be clearer with your question and what you're working with if we're to be able to help you though.

      Comment

      Working...