SubReport Problem (Lebans Justified)

B

B

I want to apply Lebans Justify Text ActiveX control in a subreport with the
following code in main report but it doesn't work. Please help.

Option Compare Database
Dim Justi2 As New clsJustifyText
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Call Justi2.fRecordSection(Me, Me!subform_name!control, PrintCount)
End Sub
 
S

Stephen Lebans

First of all the solution is not an ActiveX control. Secondly since the
solution uses the report's Page event it cannot be used in SubReports.

I believe the JustifyText ActiveX control on my site should work on a
SubReport.
http://www.lebans.com/xjustifytext.htm

--

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

B

Sorry, Stephen. I am new to Access VB so I don't know how to distguish what
is ActiveX control. The justifytext tool that I used was download from your
website. I have copied the class module and paste it in my Access database. I
have also copied the code from Report.rptClassJustifyText and changed it to:

Call Justi2.fRecordSection(Me, Me!subform_name!control, PrintCount)

but it doesn't work. I dont' know what I have done wrong. Could you please
help me? many thanks.
 
B

B

I get it. I mixed up Justify Text ActiveX contorl and JustDirect.
Justify Text works on subreport. but i need to set the textbox with
canGrow/CanShrink props.
Can you please help?
 
S

Stephen Lebans

The only CanGrow solution that will work for SubReports is the TextBox
control's Distribute alignment option. THis is available with A2K or
higher. Be aware though, there is a known bug whereby the last line of
the text is fully distributed across the width of the entire line.

--

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Justidirect - Justifying text in Access report not working - Help,please. 0
Run-Time Error 75 4
JustiDirect Stephen Lebans and IntFS. 0
pdf thumbnail in access report 0
Access2007 won't run report event procedures (e.g. Detail Format) 2
Page Totals Code error 2
3 labels per report page problem 0
3 labels per page - Allen Browne or FredG maybe??? 0

Top