Drop-Down List on Data Access Page

[Terry Roberts]

I added a drop-down list control to a DAP, entering the
values manually to prevent the time overhead of having to
query a table (the control is a State selector). Using the
wizard, I entered a 2-column list of states and their
abbreviations. (i.e.; AB Alberta, AK Alaska, etc.)

I'm having two problems with the control.
1) The drop-down list only displays the second column of
my two-column list. When clicked on, states from Alberta
to Yukon can be seen, but no abbreviations appear.

2) There does not seem to be anywhere to go back into the
list to make changes or additions/deletions. I've brought
up the properties dialog for the control, but cannot find
the source list anywhere. I do have the control bound to a
field in my underlying table (and when I select a state
using the control, the abbreviation is correctly recorded
in the associated State text box), so I tried removing the
link to the underlying field. No dice. I do NOT have any
values entered for the ListRowSource, ListDisplayField, or
ListBoundField.

BTW, if it matters, this is a SQL-based project, using a
locally hosted copy of MS SQL Server Personal edition.

Any tips on remedying these problems would be greatly
appreciated!

TIA,

Terry Roberts