combobox no selection

  • Thread starter Thread starter RedBeard
  • Start date Start date
R

RedBeard

How would I go about creating a command button that resets a combo box
to a "pristine state" i.e. nothing selected?

Thanks!
 
If your button is on the form then the click event would have this line of code

Me.NameOfCombobox = Null

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
RedBeard said:
How would I go about creating a command button that resets a combo box
to a "pristine state" i.e. nothing selected?
Click to expand...


The others have pointed out how to clear a normal combo box. If you are
using Access 2007, and your combo box is bound to a multi-value field and
allows multiple selections, then that method won't work. If that is the
case, you can clear the combo box by setting its value to an empty array,
like this:

Me.MyComboBox = Array()

Remember, that will only work, and will only be necessary, if the combo box
supports multiple selections.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I ran Macrium Reflect Free. 6
Re: Pass field value selected in Combo Box to SQL Query 1
Opening Forms based on Combo Box Selection (Access 2007) 1
Need combo box to refresh when moving to new record 2017 1
Combo box with null value 3
Access Microsoft access database(creating a search engine form) 0
Access Combobox in Access Visible based on Checkbox 0
Filling More than one field a combobox selection 2

Back
Top