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  

JUSTIFIED ALIGNMENT IN ACCESS REPORTS



 
 
Thread Tools Display Modes
  #1  
Old October 2nd, 2004, 07:28 AM
CHANDRASEKARAN
external usenet poster
 
Posts: n/a
Default JUSTIFIED ALIGNMENT IN ACCESS REPORTS

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.
  #2  
Old October 2nd, 2004, 11:58 AM
Peter R. Fletcher
external usenet poster
 
Posts: n/a
Default

I don't believe so. Have you considered merging the data into a Word
Document?

On Fri, 1 Oct 2004 23:28:38 -0700, "CHANDRASEKARAN"
wrote:

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.



Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
  #3  
Old October 4th, 2004, 02:20 AM
Stephen Lebans
external usenet poster
 
Posts: n/a
Default

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 he
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 he
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.


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


 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
access to websites/hyperlinks in reports? RusCat Setting Up & Running Reports 4 September 17th, 2004 06:18 PM
Adding staff photographs to my database KK New Users 2 September 3rd, 2004 07:41 AM
Upload Image Jason MacKenzie General Discussion 1 September 1st, 2004 04:38 AM
Can not open reports in Access 2003.. SJ Setting Up & Running Reports 9 July 9th, 2004 03:45 PM


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