I have a form with a combobox that I'd like to limit input. Before I can do that, I have to find a way to allow the user to see what the abbreviation in column 1 of the combobox dropdown table from column 2 of the table.
Table combobox is based on:
Spec SpecN Active
HC Hoary Yes
CT Canada Yes
TEA Teas Yes
Spec is short text (size 6). I inserted the SpecN column as short text (size 25). Active is Yes/No
When I go to the form and select the property sheet, I change the column count to 2 and then column widths to 1";1" The resulting display is "Yes"
If I change the column width to 0";1" the resulting display is "Yes"
I haven't had to work with Access in a long time, so any help in getting "Hoary" to show up when a user scrolls through the dropdown to HC and "Canada" to display as the user scrolls past CT is appreciated. If there is something even simpler like a large tooltip listing all 32 rows when the user clicks on the dropdown, that wouldn't be optimal but could work too.
Thanks