text length in a text box versus memo field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Warden - 11 May 2007 17:49 GMT

I have created a reoprt that uses a memo field. The problem I am having is
that not all of the text in the memo field is showing up in the txtbox of the
report. I have set the properties of the report field (data source
qry!memofield) to can grow "yes" and have made the text field larger than
needed on the report, but when I preview the Report or print it the text box
in question only shows 202 charactures/spaces out of 310 in the tables memo
field. How can I get the report to show and print all the information from
the memo field. Could my text length be limited to the fact that I am passing
the information through a query?

Reply to this Message

John W. Vinson - 11 May 2007 22:06 GMT

>I have created a reoprt that uses a memo field. The problem I am having is
>that not all of the text in the memo field is showing up in the txtbox of the
[quoted text clipped - 5 lines]
>the memo field. Could my text length be limited to the fact that I am passing
>the information through a query?

It could be - you cannot Sort or Group By a memo field, nor can you use a
UNION query or a Unique Values query, without truncating memos. The other
culprit is that you cannot use *ANY* Format property on a Memo field, or a
textbox containing a memo field, without Access truncating it.

John W. Vinson [MVP]

Reply to this Message

Warden - 14 May 2007 13:47 GMT

I guess it is just one of the quirks of the system. I removed the "All
caps(>)" formating in the text box and all of the text shows up. However on a
hunch I used the report wizard to recreate the report, and all of the text
showed up. i had even gone into the properties or the wizard generated report
and change the format to "all caps (>) " and all the text showed up. when I
compared the properties for the two reports i could not find any differences.
chalk this up to lessons learned.

Thank you
Warden

> >I have created a reoprt that uses a memo field. The problem I am having is
> >that not all of the text in the memo field is showing up in the txtbox of the
[quoted text clipped - 12 lines]
>
> John W. Vinson [MVP]

Reply to this Message