Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Memo field shows only 3 first lines in a report

Status
Not open for further replies.

matrec

Technical User
Feb 19, 2005
19
CY
Hi,
I have a table with 5 Memo fields.
I fill each Memo field from a form and then use each field in a report.
The problem I have is that for some Memo fields, the report showes only a part of it , first 3 lines. I changed the Can Grow, Can Shrink properties into Yes, of the report's field but still the problem is there. Any clues as to what I am doing wrong? I use Access 2000.
Thanks
 
Can I ask a silly question are the first three lines auto generated or test data and are they NEW or data being cut off - lastly do you have a size set for the field any where.

I know these sound dumb questions but.. I spent time on similar only to find I wasn't adding to the field just overwriting with same data so it looked as though only first few lines were appearing.

regards

jo
 
Try to change the font name, font size, font weight.
It helped me.
 
Thank you both.
The data in the Memo field is a text which never changes. It is part of a letter, let's say.
May be the problem has to do with the properties of a Memo field used on a report. Maybe there is a maximum of characters it can show on the report, though it holds many more in the table.
Rgds
 
just as an aside here you have goth the can shrink can grow property set to yes on the filed attributes.

regards

jo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top