A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Distributed" Text alignment in reports - Carriage return...??



 
 
Thread Tools Display Modes
  #1  
Old January 17th, 2005, 12:17 AM
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
  #2  
Old January 17th, 2005, 02:56 AM
Stephen Lebans
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Outline Renee Hendershott Page Layout 2 December 25th, 2004 03:49 PM
Can I change the vertical alignment of text in a text box? Fien Page Layout 2 November 25th, 2004 04: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 07:07 PM
Text boxes-help Jon Peltier Charts and Charting 0 January 26th, 2004 06:46 PM


All times are GMT +1. The time now is 07:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.