This is a bug/feature of the Distribute property. Unfortuntaley 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.