Jusify text in a letter

[rinova]

Hi,

I'm creating a form letter in Access 2002 and the letter is completed but I want to change the formatting from align left to justify but can't find a way to do this. The detail section contains 2 label boxes and 1 text box.

Can this be done?

 

[David R]

Properties > Format > Text Align: Distribute

 

[rinova]

This works with one issue, if the last line is a 2 to 4 words the distribute format extends the words to the end of the line. instead of leaving it as is.

Example:
Dear brothers and sisters, when troubles come your way, consider it an opportunity for great joy.

will look like this:
Dear brothers and sisters, when troubles come your way, consider it an
o p p o r t u n i t y f o r g r e a t j o y.

The last line in the text box is always justified and I don't want the last line being justified. Any workarounds for this problem?

Thank you.

 

[David R]

http://bytes.com/topic/access/answers/946748-justify-long-text-report references an ActiveX control that will allow for true Justify rather than Distribute, otherwise I don't know of anything that will help much here, sorry.

You may want to fiddle your textbox width or wording to make it so this effect is less noticeable? Sometimes you can 'save' it from wrapping to a new line of 2-3 words, but it depends on how variable your form letter text is.

 

[rinova]

I understand it's a limitation or flaw in Access format within reporting. Wonder if the latest version has this problem? I will try the ActiveX control and let you know if it worked.

Thank you again.

 

[David R]

I'm using 2010 and it still lacks a Justify option. I saw nothing in a quick Googling that led me to believe it's changed for 2013 either...

 

[rinova]

You did it again David!

I was able to download the ActiveX control, install it and then edit my report using the ActiveX control called Access Justification Control ver2.

I simply used the Insert menu and select ActiveX controls. The ListBox that pops up contained a listing "Access Justification Control ver2". Once the control is inserted into my Report I can double click it and select Properties to get to the control's properties.

Downside is you need to install this ActiveX control on all systems but I need it only on one, so it works for me.

Thank you again David.

 

[David R]

Glad that worked for you, I try to stay away from the third-party ActiveX stuff for maintainability, but sometimes it's needed...

 

[Richard M]

Hi,

I am having the same problem with wrapping text. I have looked everywhere, but can not find it. Where do I find "ActiveX control called Access Justification Control ver2" and how do I download it into A2007?

Richard

 

[rinova]

Hi,

I am having the same problem with wrapping text. I have looked everywhere, but can not find it. Where do I find "ActiveX control called Access Justification Control ver2" and how do I download it into A2007?

Richard

I apologize for the delayed response to your question. Just in case anyone else is looking for this ActiveX control it's located at http://www.lebans.com/xjustifytext.htm

Hope this solves your issue.