By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,377 Members | 1,665 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,377 IT Pros & Developers. It's quick & easy.

inserting all listbox items into a single field in access

P: 1
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?
Jun 14 '15 #1
Share this Question
Share on Google+
2 Replies

Seth Schrock
Expert 2.5K+
P: 2,951
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.
Jun 14 '15 #2

Expert Mod 15k+
P: 31,768
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.
Jun 14 '15 #3

Post your reply

Sign in to post your reply or Sign up for a free account.