The field is toosmall to accept the amount ofdata you attempted to

  • Thread starter Thread starter New
  • Start date Start date
N

New

Hi,

I am new to access. In access form i have a Combo box and the RowSource
for the Combo Box is "SELECT Description FROM DSMCode ", where the field size
of Description is 100.

If i select a description which has more than 50 char length i am getting
following error.
"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data"

I am not getting proper help from google..Please help me.
 
Open the table in design view, click on the field name. Check the size in
window below.
 
Hi Karl,

Thanks for the quick reply
My Control Source field size is 50 and i changed it to 100. Now it's working
fine..
Thanks for the help.
 
Back
Top