Cannot select first item from combobox

mwc0914

New Member
Joined
Sep 24, 2015
Messages
42
I am not an Access programmer, but got this problem to fix. I have a form with a combobox filled with the months. When I select a month from the combobox, I can select any month but January, the first item listed in the combobox. When I click on the down-arrow to view the dropdown list, I noticed the January element has a line under, like it is separate from the rest of the list. I can hover my mouse over the January item, but when I click, nothing happens. When I try typing Jan in the box, I get an error message saying "The text you entered insn't an item in the list", but when I look at the combobox properties, the row source property contains "JAN";"FEB";"MAR";"APR";"MAY";"JUN";"JUL";"AUG";"SEP";"OCT";"NOV";"DEC"

How can I select the Jan item?

Thanks
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Is the comboboxes Column Heads property set to True?

If it is then 'JAN' is probably being treated as a header.
 
Upvote 0
Norie has hit the nail on the head.
I was able to create the same problem using his advice.
I have never ever used that option. :)
 
Upvote 0

Forum statistics

Threads
1,221,692
Messages
6,161,351
Members
451,697
Latest member
pedroDH

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top