How to Make a List Box a Drop-Down Like a Combo Box in Access

0
votes

in access 2007 How to Make a List Box a Drop-Down Like a Combo Box without changing it to combo box type because it has multi select property and i need to save some space on my form is that possible ??

1
ms-accessms-access-2007vba

1 Answers

1
votes

if there is enough space under ListBox try to format->bring to front and assign events 

Private Sub MutantListbox_GotFocus()

    MutantListbox.Height = MutantListbox.Height * 10 ' it waz 1 line become 10

End Sub 

Private Sub MutantListbox_LostFocus() 

    MutantListbox.Height = MutantListbox.Height / 10 ' it waz 10 line become 1

End Sub