• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

How do I add lines with several fields in Access 2007 List_Box with "Value List" Property?

the listbox method "Additem" has only two parameters: a string with the value to insert, and an integer with the index in which we want to position the new item. But what if we want to insert a line with several values? is it incompatible with the "Value List" setting?
1 Solution
You can by delimiting with a semi colon

AddItem "col1;col2;col3"

ensure number of columns set accordingly though

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now