SubReport Problem (Lebans Justified)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

B - 21 Jun 2005 02:06 GMT

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

Reply to this Message

Stephen Lebans - 21 Jun 2005 02:54 GMT

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.

> 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.
[quoted text clipped - 4 lines]
> Call Justi2.fRecordSection(Me, Me!subform_name!control, PrintCount)
> End Sub

Reply to this Message

B - 21 Jun 2005 03:14 GMT

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.

> 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.
[quoted text clipped - 20 lines]
> > Call Justi2.fRecordSection(Me, Me!subform_name!control, PrintCount)
> > End Sub

Reply to this Message

Stephen Lebans - 21 Jun 2005 16:08 GMT

Please reread my initial reply to you.

--

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

> 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
[quoted text clipped - 30 lines]
> > > Call Justi2.fRecordSection(Me, Me!subform_name!control, PrintCount)
> > > End Sub

Reply to this Message

B - 23 Jun 2005 09:57 GMT

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?

> Please reread my initial reply to you.
>
[quoted text clipped - 49 lines]
> PrintCount)
> > > > End Sub

Reply to this Message

Stephen Lebans - 23 Jun 2005 16:40 GMT

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.

> 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
[quoted text clipped - 54 lines]
> > PrintCount)
> > > > > End Sub

Reply to this Message