Hi everyone. I'm relatively new to Access, and have hit a problem I just can't figure out. I have created a combo box on one of my forms. It worked just fine yesterday, but today I made a slight change to my table, and now it doesn't work quite right.
First, a quick explanation of how I made the combo box:
I set it up to have two columns: Column 1 was a number (1, 2, 3, 4), and Column 2 was a description. The value of Column 1 would be placed in a field in my table, once the user made their selection. I initially set up that field to be of data type Short Text.
The combo box was working fine yesterday. Then, this morning, I decided to change the data type of the field to Number (Integer). Now once someone makes a selection in that combo box, only the number continues to appear in the combo box after the selection is made. I change the data type back to Short Text, but this problem still occurs. I even tried deleting the combo box and recreating it, but the problem is still there.
You can see a screenshot here.
I have looked all over the Properties of the combo box to see if I can figure out how to get it to continue to show both columns once a selection is made, but I cannot figure it out. Any help would be appreciated.