text length in a text box versus memo field

[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
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?

 

[John W. Vinson]

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?

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]

 

[Warden]

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