Display dropdown items in list box

vent

Registered User.
Local time
Today, 11:09
Joined
May 5, 2017
Messages
160
Hi everyone

I have a list box with a number of records but displays 5 out of 13 columns from a query, however I need to include one more column. This additional column will be a drop down that lists items specific to each record. Originally a combo box on the form was used to display the items, however is it possible to include a drop down in a list box? So that when the user clicks and the row gets highlighted, the drop down can display the specific items to that record? In the query, this field is included at the end and the column widths are set to 2";2";2";2";2";0";0";0";0". If anyone has any guidance, that'd be much appreciated!
 
I doubt you can have a ComboBox (dropdown) within a ListBox but I know a SubForm displaying a Datasheet or Continuous Form will do it. :)
 
Last edited:
I agree with RualGuy. AFAIK, the built in Access Listbox control can't display a combo box on a row. There might be probably third-party custom control that can.


It would be easy to do what you want with a subform in continuous view. It can even be made to look like a list box but is much more powerful.

FWIW: I have started using a subform instead of a list box most of the time since the subform can do so much more.

Alternative Solution: Tool Tip

Check out Stephen Lebans: Custom Tooltip

When the user hovers their mouse over a row, a Tool Tip can pop up with additional information about the row/record.
 

Users who are viewing this thread

Back
Top Bottom