Access 2003 Combo problem

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

.

Relevant Pages

  • Re: Too many threads?
    ... This was one of the major problems ... many characters making me dizzy to follow and too many characters for ... whom I started to care less and less. ... You can't reason with someone whose first line of argument is ...
    (rec.arts.sf.written)
  • RE: How to identify two byte characters in an MFC program?
    ... and there are two major problems with them. ... SpanExcluding() doesn't return the characters after the first occurence of ... I replaced the double byte whitespaces with single byte whitespaces and then ... characters in an MFC program. ...
    (microsoft.public.vc.mfc)
  • Re: New-Line in Regular Expression
    ... really good responses. ... > # Open the file for reading and if cannot die and give error message. ... > # While the file is open read through it and remove new line characters. ... > # For each item in the array print it out. ...
    (perl.beginners)
  • Re: New-Line in Regular Expression
    ... reason: POP3 Host did not acknowlege ... > # While the file is open read through it and remove new line characters. ... > # For each item in the array print it out. ... match the date field and the time field, and stored the exact log error message ...
    (perl.beginners)
  • Re: Access 2003 Combo problem
    ... that's why your getting the error message "Too Long" ... What's happening is that you are attempting to insert the Name, not the Abv ... characters long) and the two letter combination in the other field (2 ... Chuck Buckley ...
    (microsoft.public.access.formscoding)
Loading