A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Field Size



 
 
Thread Tools Display Modes
  #1  
Old December 5th, 2008, 10:45 PM posted to microsoft.public.access.tablesdbdesign
Mani
external usenet poster
 
Posts: 54
Default 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  
Old December 5th, 2008, 11:41 PM posted to microsoft.public.access.tablesdbdesign
Beetle
external usenet poster
 
Posts: 1,254
Default 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  
Old December 6th, 2008, 12:06 AM posted to microsoft.public.access.tablesdbdesign
Clifford Bass[_2_]
external usenet poster
 
Posts: 1,295
Default 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  
Old December 6th, 2008, 12:06 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old December 8th, 2008, 03:37 PM posted to microsoft.public.access.tablesdbdesign
Mani
external usenet poster
 
Posts: 54
Default 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  
Old December 8th, 2008, 03:38 PM posted to microsoft.public.access.tablesdbdesign
Mani
external usenet poster
 
Posts: 54
Default 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  
Old December 8th, 2008, 06:17 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old December 8th, 2008, 07:17 PM posted to microsoft.public.access.tablesdbdesign
Mani
external usenet poster
 
Posts: 54
Default 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  
Old December 9th, 2008, 12:26 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old December 9th, 2008, 07:23 PM posted to microsoft.public.access.tablesdbdesign
Mani
external usenet poster
 
Posts: 54
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.