I want to do a customized address book in base. I want the full state name to show in a list box but only want the abbr. placed in the actual record. How can I accomplish this?
Hello,
First is the table - two columns - Full name & abbreviation.
Then in the list box control, in the properties on the Data tab:
Type of list contents = Table
List content = YOUR_TABLE_NAME
Bound field = 1
The table design & bound field are key elements here. The bound field starts with the first field as 0. So in using all columns in the table, the full name is field #0 and the abbreviation is field #1. The field displayed in the list box is field #0 and the field stored in the Data Field you specified is the bound field - in this case the abbreviation.
Sample ------- USstates.odb