Drop Down List - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Drop Down List

Kevin Robertson

2 years ago

I built a Drop Down List using a Combo Box and a Button (image below).
It's not perfect. You can still type in a value when the box is dropped down.
My example is using an unbound Form. If a needed on a bound Form add an On Current event to set the Caption of the Button equal to the display column of the Combo Box.

	Kevin Robertson OP @Reply 2 years ago

	Kevin Robertson OP @Reply 2 years ago
I changed this line of code `cboAdvanceDate.Width = 4920` It now reads `cboAdvanceDate.Width = CurrentDate.Width` I didn't want the width hardcoded so now it will always be the same width as the Text Box above it.

	John Davy @Reply 2 years ago
Very nice! Thanks for sharing. John

	Kevin Robertson OP @Reply 2 years ago
UPDATE: I had to add some error handling to the After Update if the Combo Box is cleared. `Private Sub cboAdvanceDate_AfterUpdate() NewDate = CurrentDate + cboAdvanceDate If Not IsNull(cboAdvanceDate) Then btnAdvanceDate.Caption = cboAdvanceDate.Column(1) End If cboAdvanceDate.Width = 240 cboAdvanceDate.Left = btnAdvanceDate.Left + btnAdvanceDate.Width btnAdvanceDate.SetFocus End Sub`

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View