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  

How do I justify text properly in a report?



 
 
Thread Tools Display Modes
  #1  
Old December 1st, 2007, 11:24 AM posted to microsoft.public.access.reports
Mervyn Watling
external usenet poster
 
Posts: 3
Default How do I justify text properly in a report?

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
  #2  
Old December 1st, 2007, 01:18 PM posted to microsoft.public.access.reports
Allen Browne
external usenet poster
 
Posts: 11,706
Default How do I justify text properly in a report?

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" wrote in message
...
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


  #3  
Old December 2nd, 2007, 02:32 PM posted to microsoft.public.access.reports
Mervyn Watling
external usenet poster
 
Posts: 3
Default How do I justify text properly in a report?

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


"Allen Browne" wrote:

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" wrote in message
...
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



  #4  
Old December 2nd, 2007, 04:54 PM posted to microsoft.public.access.reports
Stephen Lebans
external usenet poster
 
Posts: 619
Default How do I justify text properly in a report?

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" wrote in message
...
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


"Allen Browne" wrote:

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" wrote in
message
...
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





  #5  
Old August 26th, 2009, 09:55 PM posted to microsoft.public.access.reports
JD McLeod
external usenet poster
 
Posts: 60
Default How do I justify text properly in a report?

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?

"Stephen Lebans" wrote:

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" wrote in message
...
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


"Allen Browne" wrote:

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" wrote in
message
...
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





  #6  
Old August 26th, 2009, 10:28 PM posted to microsoft.public.access.reports
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default How do I justify text properly in a report?

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" wrote in message
news
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?

"Stephen Lebans" wrote:

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" wrote in
message
...
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


"Allen Browne" wrote:

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" wrote in
message
...
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







 




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


All times are GMT +1. The time now is 11:43 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.