JUSTIFIED ALIGNMENT IN ACCESS REPORTS

  • Thread starter Thread starter CHANDRASEKARAN
  • Start date Start date
C

CHANDRASEKARAN

I have developed a simple application is Access. I used
Memo field to store large amount of data. When I wnat to
take print out, I am not able to take it with the
Justified alignment. Is there any way to implement this.
 
I don't believe so. Have you considered merging the data into a Word
Document?

I have developed a simple application is Access. I used
Memo field to store large amount of data. When I wnat to
take print out, I am not able to take it with the
Justified alignment. Is there any way to implement this.
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Here's my standard answer on this issue.

A2K or higher supports a Distribute property for TextBox controls. There
is a bug/feature of the Distribute property whereby the last line of the
paragraph is fully justified even if it contains a single word.
Unfortunately 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.
 
Back
Top