I have an access form I have been using for four years without any
major problems.  Part of the data entry requires a user to enter a
state two letter designation in three places.  I am trying to modify
the form to use a combo box which displays the two letters of the
states and then allow the user to select the state.

I have established a table with the the state name in one field (30
characters long) and the two letter combination in the other field (2
characters long).

I have placed a combo box on the form I am using and see the various
two letters display.  Once selected this two letter combination is to
be displayed on the form and stored in the appropriate field the form
data goes to.  Only problem is when I select the two letter
combination a dialog warning box appears with the following message:

"The field is too small to accept the amount of data you attempted to
add.  Try inserting or pasting less data."

The field in the table where I get the two letter combination is two
characters long, and the three fields in the table where the form data
goes are all two characters long.  Any one have an idea what is
generating this error message?

The Row Source statement looks like this:

SELECT [tblState].[StateName], [tblState].[StateAbv] FROM [tblState];

Any help would be appreciated.

Thanks

Chuck Buckley