Re: A2K - a quick one about textbox grow property

I guess I can't prevent this truncation from happening then?

You're correct, Deano! The Grouping of the Memo field is causing the
truncation! Allen Browne explains all of this in the article here:

http://allenbrowne.com/ser-63.html

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200807/1

.

Relevant Pages

  • Re: A2K - a quick one about textbox grow property
    ... The Grouping of the Memo field is causing the ... Allen Browne explains all of this in the article here: ...
    (comp.databases.ms-access)
  • Re: Group by truncating field
    ... In the Total row under your memo field in query design, use First instead of Group By. ... Truncation of Memo fields ... Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.queries)
  • Re: transfer spreadsheet
    ... Memo Field Truncated When Report Is Output to Excel ... explaining that the file format you export to might be the issue. ... truncation at 255 characters. ... Similarly, if you are exporting a query, the query will truncate the memo ...
    (microsoft.public.access.modulesdaovba)
  • Re: Lost Data
    ... If you can't delete the record, you can create a new table and import the other rows (being careful not to refer to the problem one. ... Hopefully that gets your cat off the hook. ... Allen Browne - Microsoft MVP. ... I've recently added a memo field to a table and inserted the field onto ...
    (microsoft.public.access.forms)
  • Re: Exporting a memo field
    ... its Format or InputMask property in the table definition)? ... truncation. ... If you're exporting the memo field unaltered, ...
    (microsoft.public.access.externaldata)