Software

Ask something
Discussion Locked

Access 2002 truncates Memo Field

0 helpful
6 replies

by ragman

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I moved to Access 2002 although 2000 has the same issue. I have a Memo field that is consistantly truncated when I try to output the information as part of a report. The information was originally added to the database via cut and paste from excel. Can expand and shrink have no effect. I can look at the information in the table or on a form but am limited when I get to a report. Am I toast?

6 replies

by angela.brown2

Try applying the most recent Microsoft Office service pack. Also, if the field contains more the 255 characters this may be your problem.

by ragman

Thanks, but yes the some of the information in the memo field is over 255 characters, which is the point of a "memo" field. I just can't get it to output in a report.

by alysondunsford

ragman
did your memo field have any formatting - if it does access will convert the data type of the field to text in report and form format!

by ragman

Thanks - that's what I was looking for. I'm toast, but it's another case of a fine access "feature". Just like importing a number string you want to have as a text field.

This discussion is closed to new replies.