I'm using Access 2003 and on an existing form I'm trying to convet a text box to a combo box.
I used the "Convert To" function by right clicking on the text box and selecting combo box. The control changed and looks
I left the Control Source as it was and created a SQL in the Row Source with only one field. The SQL works fine and displays
the list of values I want the combo box to display.
The bound column is 1, pointing to the only field in the SQL. The number of columns property is set to 1, as well. The Column
Width property is set to the same with as the combo box.
Now for the part that's making be crazy. When I put the form into Form View the value from the Table displays, but if I open
the combo box (dropdown) there is nothing in the list (the list area drops down, but is totally blank). I tried this with
adding a new record with the same result.
I've created hundreds of combo boxes and never had this happen. I've compared the settings with working combo boxes on the
same form and can find no relevant differences.
I am totally stumped. I know this has to be something stupid I'm overlooking, but I've got a total brain freeze about this
If anyone can give me a suggestion of something I might have overlooked or something else to try (I've already tried creating
a totally new combo box and got the exact same result (and this was even using the combo box wizard)).
TIA to anyone who responds with any helpful suggestions.