Text Restrictions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am set a memo field in a table but once the text is transferred to a report
it gets restricted / cut off - how do I remedy this??
 
Several possible causes.

1. Text box size
Make sure the text box is large enough in the report, or has its CanGrow
property set to Yes and the CanGrow of the (Detail?) section is also set to
Yes.

2. Aggregation
If the report is based on a query, check that the query is not doing any
aggregation on the memo field. For example, the query must not contain
DISTINCT. If the query as a GROUP BY clause, change it to First instead of
Group By under the memo field.

3. Formatting
Make sure there is nothing in the Format property of the memo field in the
table, and nothing in the Format property of the text box on the report.

4. Exporting
If the problem only shows up when you export the report to RTF (not when you
view or print the report in Access), see:
http://support.microsoft.com/?id=288877
 
I am having the same problem, but in going back to the query, I find that the
memo field doesn't have formatting on it nor is there any aggregate functions
in the query. Could joins possibly cause this?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Are there Data size limits in an ACCESS query? 2
Query field size quandry 2
Can rich text format (memo) carry over in a make table query? 1
Converting memo to text using query (to form a new table) 3
Adding Memo Fields Using an Append Query 4
Memo fields not displaying in query 4
Restrict memo field to size of text box 2
Totals query and Memo field 3

Back
Top