RE: The field is too small to accept . . .
- From: Jerry Whittle <JerryWhittle@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 26 Apr 2006 05:46:01 -0700
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.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"Fancy1" wrote:
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?
- Follow-Ups:
- Re: The field is too small to accept . . .
- From: Fancy1
- RE: The field is too small to accept . . .
- From: jahoobob via AccessMonster.com
- Re: The field is too small to accept . . .
- References:
- The field is too small to accept . . .
- From: Fancy1
- The field is too small to accept . . .
- Prev by Date: Re: Primary Key Autonumbers
- Next by Date: Re: Phone call log, multiple fields for different times
- Previous by thread: Re: The field is too small to accept . . .
- Next by thread: RE: The field is too small to accept . . .
- Index(es):
Relevant Pages
|
