Access full justification

[Fran P.]

How do I apply full justification to an Access report's text/memo fields?
Thank you.

 

[Wayne Morgan]

See if this item from Stephen Lebans will help.

http://www.lebans.com/xjustifytext.htm

 

[Fran P.]

Thanks, Wayne, for the response. The control does help a lot. I do still
need to figure out how to emulate the CanGrow/CanShrink functions since I'm
using plenty of these text boxes. Please let me know if you have any
suggestion. Thanks again.

 

[Wayne Morgan]

I haven't tried it, but I would probably adjust the Height property of the
control in the Format event of the report's section. Another possibility may
be to concatenate multiple rows together into a single box. For an example
of this, try these links. For further help, you would need to ask Stephen,
he is usually in these newsgroups and can be reached here.

http://www.vbwm.com/submissions/display.asp?id=99
http://support.microsoft.com/default.aspx?scid=kb;en-us;287685&Product=acc2002

 

[Fran P.]

Stephen:

Thanks for the reply and for the many add-ons that you've provided on your
site. I have also downloaded and played with JustiDirect. One thing is that
if you stack the text boxes (instead of putting them side by side, as you've
provided in your example), the spacing is off between one textbox and the
next one down. I'm going to play with it and see if I can adjust the spacing
accordingly. I have about 10 or so memo-field-bound text boxes on top of one
another and each once may contain up to 25 lines of texts., so this may or
may not work. I will let both of you know if I can solve this.

Fran P.

 

[Database User]

Hi i have downloaded the software from S Lebans site but i'm a bit new at
this sort of thing and i don't know what to do from them. I have the
downloaded files on disc. Now what do i have to add some code to my text?
Please help
thanks.

 

[Arvin Meyer [MVP]]

I'm not sure which one you're using but, I use one of them in a query like:

SELECT DISTINCTROW
JustifyString("frmAddingMachine","lstAdd",[Numeral],0,True) AS Expr1 FROM
tblAdd;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Arvin Meyer [MVP]]

Oh, and you just import the modules into your own database.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
the

 

[Database User]

I managed to get the fully justifyed code but now i want to fully justify an
unbound box with quite a few lines of code and text - how do i do this?

it was only giving me options to justify a field from the table or query.

thanks for your help

 

[Database User]

Hello can someone help me further i've almost got there with this fully
justified thing but i'm quite new and i need step by step instructions.

so i've been able to go to insert activex control and chosen the fully
justify one but i cant seem to apply it to an unbound field in my
report/letter that contains about 3 lines of code - what do i need to do

please explain

thanks

 

[Database User]

Hi thanks all for your help in the end the instructions on the folders i
downloaded from stephen lebans site help me. Thanks a million it works great!!