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 sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Line breaks in Access Reports

Status
Not open for further replies.

jenwalton

Technical User
Oct 25, 2001
7
US
I am new to using Access, but I think my report works okay, except long strings of data I have in "memo" fields shows the line break symbol ("?") instead of actually letting the text wrap.

Any ideas?

Thanks so much!
 
Hi. I think if you open the report in design view and in your report detail section you should right click on the memo field and set the memo field property Can Grow to Yes.
 
There is a way around this problem. In the control source of the Fieid use "=Replace([memofield],String causing problem,vbcr)

Best of luck
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top