Field Size

[Mani]

Hi! As I am entering data, a message pops up "The field is too small to
accept the amount of data you attempted to add. Try inserting or pasting
less data". The text I'm tyring to select is American Indian/Alaska Native,
Non-Hispanic or Latino. In the table that was designed; the field size is
set to 65. I don't understand why am I not able to select this, when I can
see it in the field when I select. Please help me.

 

[Beetle]

Increase the field size. Text fields can be up to 255. If you need
more than that, use a memo field.

 

[Clifford Bass]

Hi,

There is probably more in the field that is actually showing. This can
include a CR/LF, even in a single line box, that makes the box look empty.
Try using your left and right arrow keys to move as far to the left and right
as you can. My guess is that you will find some other stuff.

Clifford Bass

 

[John W. Vinson]

Hi! As I am entering data, a message pops up "The field is too small to
accept the amount of data you attempted to add. Try inserting or pasting
less data". The text I'm tyring to select is American Indian/Alaska Native,
Non-Hispanic or Latino. In the table that was designed; the field size is
set to 65. I don't understand why am I not able to select this, when I can
see it in the field when I select. Please help me.

If you're selecting more than 65 *bytes* - bear in mind that Unicode
characters may be two bytes long! - you'll get this error. Try increasing the
size of the field to 255, or use a Memo field if that's not enough.

Another possibility is that you have fallen victim to the "Lookup Field"
misfeature. If this is a Lookup Field, it's actually a Number 4 bytes long,
and pasting text into it will fail.

 

[Mani]

Hi! Thanks for the information. However, I've changed the field size to
255, and still giving me the same message. Then I I resorted to changing the
data type to memo, but it is still giving me the same message. Please
help...

 

[Mani]

I've done what has instructed here, but neither worked. I am still
gettting the same message.

 

[John W. Vinson]

Hi! Thanks for the information. However, I've changed the field size to
255, and still giving me the same message. Then I I resorted to changing the
data type to memo, but it is still giving me the same message. Please
help...

Well, more information needed! What's the structure (fieldnames and datatypes)
of your table? Into which field are you inserting data? How are you inserting
data: into the table directly (not a good idea), into a textbox on a Form, via
a Query?

 

[Mani]

I am entering information through a Form. The table has 2 columns (
Ethnicity and Code) and those are the name of the fields. Initially, the
data type for Ethnicity was Text. Then I changed the field size to 255,
still didn't work, and then I changed the data type to Memo, and still it
didn't work.

 

[John W. Vinson]

I am entering information through a Form. The table has 2 columns (
Ethnicity and Code) and those are the name of the fields. Initially, the
data type for Ethnicity was Text. Then I changed the field size to 255,
still didn't work, and then I changed the data type to Memo, and still it
didn't work.

Could you post some examples of the values you're inserting? Are either of
these fields defined as Lookup Fields? If so that's your problem!

 

[Mani]

Thanks. I figured it out. I didn't go to the main table that stored the
data, instead I went to the Ethnicity table. Anyways, got it...