If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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 |
#2
|
|||
|
|||
Here is a snip from a previous post of mine on thsi issue:
1) A2K or higher supports a Distribute property for TextBox controls. There is a bug/feature of the Distribute property whereby the last line of the paragraphi is fully justified even if it contains a single word. Unfortunately there is no fix for this issue. 2) The Justify ActiveX control for Forms or Reports he http://www.lebans.com/xjustifytext.htm Produce Fully Justified Text. Bind this control to your Memo field to create professional looking reports! This is an ActiveX control that can act as a Label or TextBox. This control has a RecordSource just like a normal Access TextBox so it can be bound to a field or contain a calculated expression. Developed for Microsoft Access97. Requires VB6 Runtime files. 3) The RTF ActiveX control for Forms or Reports he http://www.lebans.com/richtext.htm RTF2 control is an ActiveX RTF solution written in VC++. The RTF2 control is a complete editing/printing solution for Access 97 or higher. Autosizing of the RTF2 control is supported for A2K or higher. -- HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. "Olly Gregory" Olly wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outline | Renee Hendershott | Page Layout | 2 | December 25th, 2004 02:49 PM |
Can I change the vertical alignment of text in a text box? | Fien | Page Layout | 2 | November 25th, 2004 03:47 PM |
Concatenatd fields in a query for a searching form | Marc | Running & Setting Up Queries | 8 | October 19th, 2004 08:49 PM |
Return text to cell other than the one with the formula in it? | Jason | Worksheet Functions | 3 | February 25th, 2004 06:07 PM |
Text boxes-help | Jon Peltier | Charts and Charting | 0 | January 26th, 2004 05:46 PM |