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  

Memo Field Truncates my Data in Table?!



 
 
Thread Tools Display Modes
  #1  
Old March 16th, 2010, 08:41 PM posted to microsoft.public.access.tablesdbdesign
Nkryption
external usenet poster
 
Posts: 1
Default Memo Field Truncates my Data in Table?!

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

Ads
  #2  
Old March 16th, 2010, 09: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" [email protected] wrote in message news:[email protected]
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

  #3  
Old March 16th, 2010, 09:10 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Memo Field Truncates my Data in Table?!

On Tue, 16 Mar 2010 20:41:32 GMT, "Nkryption" [email protected] wrote:

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

--

John W. Vinson [MVP]
  #4  
Old March 16th, 2010, 09:11 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Memo Field Truncates my Data in Table?!

On Tue, 16 Mar 2010 20:41:32 GMT, "Nkryption" [email protected] wrote:

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


Be sure there is no Format defined on the memo field, and that you're not
sorting by it.

--

John W. Vinson [MVP]
  #5  
Old March 17th, 2010, 12:58 PM posted to microsoft.public.access.tablesdbdesign
Nkryption via AccessMonster.com
external usenet poster
 
Posts: 1
Default Memo Field Truncates my Data in Table?!

John,

Before I answer I'd just like to say that I inherited this project from
someone else, who had no idea what they were doing and provided no notes to
me!

Soo with that said, The data is showing up in the table now and on my forms.
I noticed there was an @ symbol in some of the text controls that were added
before I took over. I removed these @ signs and the text is appearing in the
text fields.

What does @ mean in access?(besides a pain in my ass)

John W. Vinson wrote:
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

[quoted text clipped - 9 lines]

Thank you


Be sure there is no Format defined on the memo field, and that you're not
sorting by it.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201003/1

  #6  
Old March 17th, 2010, 01:47 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default Memo Field Truncates my Data in Table?!

If you are viewing in a one-line space, as is usually the case, hitting the
enter key will put into a new line, thus making it appear to be invisible.
Hitting it more times will insert more blank lines making it more invisible.
Try hitting Shift-F2 (or arrow down) to see all of the contents it to see if
this is the case.

If you have truly confirmed that it is truncating to exactly 255, then the
above would not be an explanation.






  #7  
Old March 17th, 2010, 05:15 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Memo Field Truncates my Data in Table?!

On Wed, 17 Mar 2010 12:58:39 GMT, "Nkryption via AccessMonster.com"
[email protected] wrote:

John,

Before I answer I'd just like to say that I inherited this project from
someone else, who had no idea what they were doing and provided no notes to
me!


Been there, done that, went through a lot of ibuprofen...

Soo with that said, The data is showing up in the table now and on my forms.
I noticed there was an @ symbol in some of the text controls that were added
before I took over. I removed these @ signs and the text is appearing in the
text fields.


Where is the @ sign? YOu say "text controls" - textboxes on the form? Are
these in the displayed value of the textbox or in some other property? Is it a
single @ or is the textbox filled with them?

What does @ mean in access?(besides a pain in my ass)


Nothing that I can think of. It may be something that this developer included
in the app.
--

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 05:25 PM.


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