The field is too small to accept the amount of data you attempted

[Guest]

I'm running WinXp and Access 2003.

I've got a simple combo box that's roll source is a table. The problem
started when I added a new name to the table. Her name is 19 characters in
length. When I select her name from the combo box I get the "The field is too
small...".

If I leave off the last character in her last name (18 characters) I don't
get the error.

The field type is Text and 50 characters in length.

I've got combo boxes on this form that contain data that's 25 characters in
length and dont' receive any errors.

Anyone have any ideas what going on with this combo box?

Thanks,

Paul

 

[John W. Vinson]

I'm running WinXp and Access 2003.

I've got a simple combo box that's roll source is a table. The problem
started when I added a new name to the table. Her name is 19 characters in
length. When I select her name from the combo box I get the "The field is too
small...".

If I leave off the last character in her last name (18 characters) I don't
get the error.

The field type is Text and 50 characters in length.

I've got combo boxes on this form that contain data that's 25 characters in
length and dont' receive any errors.

Anyone have any ideas what going on with this combo box?

Thanks,

Paul

What are the RowSource of the combo (please post the SQL), the Bound Column,
and the datatype of the field in which you're trying to store the result?
Might the latter be a Lookup Field?

John W. Vinson [MVP]

 

[Guest]

I found the problem. This is one of those databases you inherit. I thought
the problem was the field size in the table I created for the row source. It
turned out that it was the size of the control source field that was set to
18 characters.

Thanks for the reply and have a good day,

Paul