View Single Post
  #2  
Old March 16th, 2010, 10:00 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Memo Field Truncates my Data in Table?!

Nkryption,

Since you are in the table and not a query the only other thing I can think
of is your are changing the Data Type in a linked table OR you need to
expand the field for it to show you all the data... *unless* you are typing
into a query?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Nkryption" u58794@uwe wrote in message news:a51c3432199fb@uwe...
Ok - from what I understand a "MEMO" field type should allow at least 65k
worth of data to be saved in your database table. However, I am manually
opening my table and typing in text that is a half a dozen sentences and
when
I hit enter to move onto the next field - it truncates my data. I go back to
the field in the table and only 255 characters exists.

Can someone please explain wtf is going on here? Yes, I'm absolutely certain
in database design the "MEMO" type is selected. This does not make sense to
me, and I'm not very familiar with access(I'm a SQL 2005 guy personally).

Please help, any insight is much appreciated!!!

Thank you