Text Box - Right/Left Justify

[Alan Z. Scharf]

Is there a way to justify the contents of a text box agains both the left
and right margins, newspaper style, as is possible in Word?

If not, are there any third-party controls that would do it?

Thanks.

Alan

 

[Allen Browne]

There is an option to justify, but it makes a mess out of the last line.

This one will work better:
http://www.lebans.com/justidirect.htm

 

[Alan Z. Scharf]

Allen,

Thanks very much.

Do you know if it will work with an Access ADP file connected to SQLServer
TEXT field, equivalent to MDB large text MEMO field? I forgot to
indicate
that in my request.

Regards,

Alan

 

[Allen Browne]

Haven't tested it, but Stephen's stuff is generally good.

Give it a shot, and report back, so anyone else researching this has an
answer.

 

[Alan Z. Scharf]

Allen,

Stephen Lebans' Justify control works beautifully in Access ADP off
SQLServer TEXT field.

However, I'm using it in a subreport, and when the subreport is places on
the main report, the control appears blank. It must have something to do
with instantiation and control references, which I haven't figured out.

But the control is excellent for a main report. Why couldn't Access have
this feature??!!

Regards,

Alan

 

[Stephen Lebans]

JustiDirect CANNOT work in Subreport setting. It relies on the report
object's Page event which is not fired when a report is used as a SubReport.

If you can live without full CanGrow/CanShrink functionality involving
Growing over multiple pages then you can use one of the two other solutions
on my site:

1) http://www.lebans.com/xjustifytext.htm
NEW Version 2.0 Justify Text ActiveX Control!
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.

2) 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. This is a full automatic
install package. This install package contains 3 required files for the
control to function. The OCX itself, RTF2.OCX and the 2 VC runtime files,
Mfc42.Dll and Msvcrt.Dll.

Option #1 is very easy to implement as no coding is required but offers no
CanGrow/Shrink support. Option #2 would require some fairly straightforward
coding and does support CanGrow/Shrink on individual pages but not acros
multiple pages..

--

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