Thread: Field Size
View Single Post
  #4  
Old December 5th, 2008, 11:06 PM 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]