Access get values in multi column listbox

Murray Brown
Murray Brown used Ask the Experts™
on
Hi

I have a listbox with multiple columns
I know that List1.Value will give me my key value
but I also want to concatenate column indexes 1, 2 and 3
How do I get that from the selected line using Acces VBA's click event?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
Murray,

  Use the column property:

  = Me.MyComboControl.Column(x)

 Where x is the column #.  The # is zero based (first column is column 0)

Jim.
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
thanks very much

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial