Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How do I justify text properly in a report?

1,846 views
Skip to first unread message

Mervyn Watling

unread,
Dec 1, 2007, 6:24:00 AM12/1/07
to
I am collating school reports using Access 2003. In the final Report the text
boxes are all aligned LEFT, but I want to justify the text across the box, so
the right & left edges are aligned. However, the only options I seem to have
are General, Left, Right, Centre or Distribute.
General still gives me a left-alignment. Distribute does the job, but the
last line in the box is spread all over as well, rather than aligned left (MS
Word does it properly ...). How can I justify the text so it looks right?
--
Mervyn W

Allen Browne

unread,
Dec 1, 2007, 8:18:33 AM12/1/07
to
Stephen Lebans has an ActiveX control that reputedly handles the last line
correctly:
http://www.lebans.com/xjustifytext.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mervyn Watling" <Mervyn...@discussions.microsoft.com> wrote in message
news:A5815D5F-7FEA-4A76...@microsoft.com...

Mervyn Watling

unread,
Dec 2, 2007, 9:32:01 AM12/2/07
to
Thank you for this speedy response - much appreciated!
I tried this control - it seems very good, but unfortunately I wasn't able
to use it because it did not allow me to set it "to grow". Because each box
in the report varies with size (depending upon how much the teacher has
written in the report) this would have left large gaps all over the final
printout.
Thanks again for your help, though!
--
Mervyn W

Stephen Lebans

unread,
Dec 2, 2007, 11:54:52 AM12/2/07
to
Did you try this solution?
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.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Mervyn Watling" <Mervyn...@discussions.microsoft.com> wrote in message

news:F0EDAAD1-031C-47FC...@microsoft.com...

JD McLeod

unread,
Aug 26, 2009, 4:55:01 PM8/26/09
to
When i try to open the justdirect.htm file it tells me that i am trying to
open a read only file and it won't let me proceed. I tried to open the file
and i also tried to save it to my machine and open if from there. any
thoughts?

Douglas J. Steele

unread,
Aug 26, 2009, 5:28:29 PM8/26/09
to
I believe Stephen's expectation was that you'd download the justidirect.zip
sample database from that page.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"JD McLeod" <JDMc...@discussions.microsoft.com> wrote in message
news:D0C7DFA2-2A38-476B...@microsoft.com...

0 new messages