The field is too small to accept . . .

  • Thread starter Thread starter Fancy1
  • Start date Start date
F

Fancy1

I'm new & just started to learn Access so please, use English in the answer.

I created your regular db, Name, Address, Address2, city, state, zipcode.
I used the Input Mask so the ZipCode would input would be easy for me.
However, I keep getting this error message:
"The field is too small to accept the amount of data you
attempted to add. Try inserting or pasting less data."

I tried everything to get this error message to stop. I tried to change
the Field Size from 50 to 9, nothing worked. I tried to change it from
9 to 5, that didn't work. I tried to delete the column, replace all the
zip codes, that didn't work. I changed the width on the column manually,
that didn't work. I tried to change the field to Number instead of Text,
that didn't work. This error message just won't go away. I have been
trying to 'paste' in the zip codes. They do paste, but I still get that
error message.

I tried to stand on my head, hold my breath & pray, that didn't work
either! LOL! Why do I keep getting this error message?
 
I don't understand why you would try to make the field smaller when you're
getting a message telling you that the field is too small!

How exactly are you trying to populate the field: are you typing the zip
code into the text box or are you trying to cut and paste?
 
Sometimes when cutting an pasting you get more characters than you bargained
for. Also you might be getting some non-printable ASCII characters that won't
work with the input mask. If you manually type in the zip code, does it work
then?

Also consider not using an input mask at all for the zipcode or phone
numbers if you ever think that your database may contain foriegn addresses.
Postal Codes in most countries look nothing like zip codes and won't fit the
input mask. Same goes for many telephone numbers especially those not in
North America.
 
Additionally, you should use at least First_Name, Last_Name and not just Name.
You can combine them any way you want for reports or forms via queries later
biut it is just good table design to seperate them.

Jerry said:
Sometimes when cutting an pasting you get more characters than you bargained
for. Also you might be getting some non-printable ASCII characters that won't
work with the input mask. If you manually type in the zip code, does it work
then?

Also consider not using an input mask at all for the zipcode or phone
numbers if you ever think that your database may contain foriegn addresses.
Postal Codes in most countries look nothing like zip codes and won't fit the
input mask. Same goes for many telephone numbers especially those not in
North America.
I'm new & just started to learn Access so please, use English in the answer.
Click to expand...
[quoted text clipped - 15 lines]
I tried to stand on my head, hold my breath & pray, that didn't work
either! LOL! Why do I keep getting this error message?
Click to expand...
Click to expand...
 
Douglas said:
I don't understand why you would try to make the field smaller when you're
getting a message telling you that the field is too small!

How exactly are you trying to populate the field: are you typing the zip
code into the text box or are you trying to cut and paste?
Click to expand...
I was trying everything & anything. I was typing in American zip codes.
And I started getting that error message. Then it said in the next
message, I should try to cut & paste. So I started cutting & pasting. I
thought it would go faster if the cells had predefined spaces. This way
I wouldn't have to put in the dashes.
 
Jerry said:
Sometimes when cutting an pasting you get more characters than you bargained
for. Also you might be getting some non-printable ASCII characters that won't
work with the input mask. If you manually type in the zip code, does it work
then?

Also consider not using an input mask at all for the zipcode or phone
numbers if you ever think that your database may contain foriegn addresses.
Postal Codes in most countries look nothing like zip codes and won't fit the
input mask. Same goes for many telephone numbers especially those not in
North America.
Click to expand...

Sometimes, it did work when I tried to manually type in the zips. I'm
using American phone numbers & zips for this database. I thought the
mask would cut down on the time.
 
jahoobob said:
Additionally, you should use at least First_Name, Last_Name and not just Name.
You can combine them any way you want for reports or forms via queries later
biut it is just good table design to seperate them.

Jerry said:
Sometimes when cutting an pasting you get more characters than you bargained
for. Also you might be getting some non-printable ASCII characters that won't
work with the input mask. If you manually type in the zip code, does it work
then?

Also consider not using an input mask at all for the zipcode or phone
numbers if you ever think that your database may contain foriegn addresses.
Postal Codes in most countries look nothing like zip codes and won't fit the
input mask. Same goes for many telephone numbers especially those not in
North America.
I'm new & just started to learn Access so please, use English in the answer.
Click to expand...

[quoted text clipped - 15 lines]
I tried to stand on my head, hold my breath & pray, that didn't work
either! LOL! Why do I keep getting this error message?
Click to expand...
Click to expand...
Click to expand...
Thanks guys! I just took Allen's advice & read the KB from MS. I'll do
that workaround!
 
Back
Top