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

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.
 
K

KARL DEWEY

Open the table in design view, click on the field name. Check the size in
window below.
 
N

New

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

3163 The field is too small to accept the amount of data 1
"field too small to accept amount of data you attempted to add" er 2
The Field is too small to accept the amount of data you attempted 3
Access 2003 Combo problem 2
Referring to text control in a form 2
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting l 1
Email via Access Form 1
Runtime error - Field is too small 2

Top