Justifying a Memo field

[Ernie]

I am trying to fully justify text in a memo field. There
doesn't seem to be an icon available to do this. Does
anyone know of any code that would achieve a left and
right justified appearance?

Thanks, Ernie

 

[Guest]

You could try setting the Text Align property to Distribute. This is the nearest to justify I have found in Acces

Sheila

 

[Guest]

I'm having the same problem. "Distribute" choice did not help. The only way I could figure out around this problem was to publish my 27 page report in Word and then use the word document to finalize my report, just to get the justified paragraphs. Microsoft needs to add this feature to Access!

 

[Stephen Lebans]

Here's my standard answer on this issue.

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
paragraph is fully justified even if it contains a single word.
Unfortunately there is no fix for this issue.

There are several other options on my site:

1) For Reports only:
http://www.lebans.com/justidirect.htm
JustiDirect.zip is a database containing Functions to produce fully
justified text within standard TextBox controls on your Reports.
Allows a standard Access TextBox, bound to a Memo field to not only
produce fully justified text, but use the CanGrow/CanShrink properties
as well.

2) The Justify ActiveX control for Forms or Reports here:
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 here:
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.

I'm having the same problem. "Distribute" choice did not help. The

only way I could figure out around this problem was to publish my 27
page report in Word and then use the word document to finalize my
report, just to get the justified paragraphs. Microsoft needs to add
this feature to Access!