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

Tabs in a Listbox?

P: 10
Using MS Access 2003 I am currently populating a listbox via a query where I concatenate 2 string fields seperated by a "-". The fields are a description along with the key so when the user makes a selection I can then retrieve the appropriate values.

The values are running together and difficult to read. Is there a way I can incorporate Tabs in the Query so that additional VBA code won't be needed on the form?
Dec 26 '07 #1
Share this Question
Share on Google+
4 Replies


FishVal
Expert 2.5K+
P: 2,653
What about Listbox with several columns?
Dec 26 '07 #2

FishVal
Expert 2.5K+
P: 2,653
Ok. I'd like to clarify what I've meant.

Multicolumn listbox is the same listbox control but tuned to display several fields aligned to columns.
Ensure that Listbox.RowSource property contains query/table returning several fields you need. Set ListBox.ColumnCount property to the number of the fields. Set ListBox.ColumnWidths property to appropriate column widths separated by semicolon.
Dec 26 '07 #3

P: 10
Ok. I'd like to clarify what I've meant.

Multicolumn listbox is the same listbox control but tuned to display several fields aligned to columns.
Ensure that Listbox.RowSource property contains query/table returning several fields you need. Set ListBox.ColumnCount property to the number of the fields. Set ListBox.ColumnWidths property to appropriate column widths separated by semicolon.
That makes sense... but what about retrieval. Will I be able to retrieve both columns once the user selects a row?
Dec 26 '07 #4

FishVal
Expert 2.5K+
P: 2,653
That makes sense... but what about retrieval. Will I be able to retrieve both columns once the user selects a row?
Sure. Take a look at "ListBox" class "Column" property in Access help.
Dec 26 '07 #5

Post your reply

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