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