M
mthornblad
Hi
I have a form for entering Customer data. When entering a new record,
I have a lookup combo box to validate the state that the user enters.
The combo box displays the state code and the state name. (ie. Ca and
California). The state code is the bound value and the state name is
the display value.
The only time I want to display the full state name is when the user
is entering data into the form. I want the state code to be displayed
on queries, forms, and reports.
Is there a way to do this ?
Thanks in advance
Mark
I have a form for entering Customer data. When entering a new record,
I have a lookup combo box to validate the state that the user enters.
The combo box displays the state code and the state name. (ie. Ca and
California). The state code is the bound value and the state name is
the display value.
The only time I want to display the full state name is when the user
is entering data into the form. I want the state code to be displayed
on queries, forms, and reports.
Is there a way to do this ?
Thanks in advance
Mark