If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Field Size
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. |
#2
|
|||
|
|||
Field Size
Increase the field size. Text fields can be up to 255. If you need
more than that, use a memo field. -- _________ Sean Bailey "Mani" wrote: 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. |
#3
|
|||
|
|||
Field Size
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 "Mani" wrote: 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. |
#4
|
|||
|
|||
Field Size
On Fri, 5 Dec 2008 13:45:46 -0800, Mani
wrote: 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. -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Field Size
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... "John W. Vinson" wrote: On Fri, 5 Dec 2008 13:45:46 -0800, Mani wrote: 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. -- John W. Vinson [MVP] |
#6
|
|||
|
|||
Field Size
I've done what has instructed here, but neither worked. I am still gettting the same message. "Beetle" wrote: Increase the field size. Text fields can be up to 255. If you need more than that, use a memo field. -- _________ Sean Bailey "Mani" wrote: 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. |
#7
|
|||
|
|||
Field Size
On Mon, 8 Dec 2008 06:37:01 -0800, Mani
wrote: 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? -- John W. Vinson [MVP] |
#8
|
|||
|
|||
Field Size
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" wrote: On Mon, 8 Dec 2008 06:37:01 -0800, Mani wrote: 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? -- John W. Vinson [MVP] |
#9
|
|||
|
|||
Field Size
On Mon, 8 Dec 2008 10:17:01 -0800, Mani
wrote: 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! -- John W. Vinson [MVP] |
#10
|
|||
|
|||
Field Size
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... "John W. Vinson" wrote: On Mon, 8 Dec 2008 10:17:01 -0800, Mani wrote: 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! -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|