Error message - "field too small"

[penwood]

i have a combo box on a main form.

The name is cboFormulaStatus and control source is FormulaStatus.
the control source is a Text field with 20 possible characters.

The Row Source seems simple with:
SELECT [tblFormulaStatus].[FormulaStatus] FROM tblFormulaStatus ORDER BY [tblFormulaStatus].[FormulaStatus];

I only have 3 possible answers in this field. for this purpose, pretend the answers are black, blue and red. my real answers are less than 12 char.

when i am in the form, i pick one answer. i get an error message:

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

what am i doing wrong? Thanks
penwood

 

[RuralGuy]

As a test, and so you understand, there is *no* penalty of any kind for declairing a field in a table to be 50 characters and only putting 20 in there. Access does *not* reserve the room. Strange problem but try expanding the field in the table and see if it makes any difference.

 

[Banana]

there is *no* penalty of any kind for declairing a field in a table to be 50 characters and only putting 20 in there. Access does *not* reserve the room.

But what about this?

 

[RuralGuy]

And did you read the responses from the three MVP's? Did you try the test?

 

[penwood]

I fixed it. it was me. the recipient field was set at just 8 characters. i made it bigger. now all is fine.
thanks alot.