Error "Field is not large enough to hold the data....."

[WannabePrgmr]

I am working with Access 2003 and am getting a "The field into which you tried to insert or paste data is not large enough to hold the data. Try inserting or pasting less data."

I copied and pasted that from the help topics so that is not the exact word for word error.

The problem is that it only comes up with one certain choice and it's three characters long "PP5". This is the only one that has the problem out of about 25 or so choices, which are pulled from a table, most of which are longer than three characters???

Any ideas would be greatly appreciated!

Thanks

[Delerna]

Some questions that might help you find the problem.

What is the field type of the field holding the data "PP5" ?
What is the field type of the field you are trying to insert "PP5" into?
How many characters are really in the Data "PP5"?
write a query that selects that data and use Test:len(FieldName) in the query to find out how many characters.

I suspect that there might be a heap of spaces following the "PP5"
Or I have occasionally seen, in access, a carriage return character following the actual data in a field and then following the carriage return there will be a heap of erronious data following the carriage return character.
I have seen that usually in linked SQL Server tables.
Open the table in access and all you see is the normal data.
Open the table in SQL server and you see all the erronious data as well.

[WannabePrgmr]

Delerna,

Thank you so much! You nailed it! When I went into the table and clicked just after PP5 and started hitting delete, I saw about 60 or more characters hidden in there! It must have been when I pasted all that info in there, I screwed up and pasted it all in with PP5 too!

Again, thank you! It's been driving me crazy over the last few days!!!!!