View Single Post
  #1  
Old January 16th, 2005, 11:17 PM
Olly Gregory
external usenet poster
 
Posts: n/a
Default "Distributed" Text alignment in reports - Carriage return...??

I have a text box in a report linked to a 'memo' field in an access table.
The text is in the vicinity of 3kb so that returned on the report is quite
large, and forms the details section on the details for an estate agency. If
you right click the text box and open the properties window you can edit the
text alignment for the box. If you set the alignment to 'distribute' it
appears 'fully justified' as if in word. It does not however work in exactly
the same way as if there is one word left at the end of a paragraph the one
word is stretched accross an entire line - looking MOST untidy. Is there any
way I can incorporate a line of code, for example a carriage return to
eliminate this?

All replies gratefully received!

Many thanks