JustiDirect won't Deploy

[Andy]

Hi;
(Also posted in Access.Reports NewsGroup)

Used Lebans.com's JustiDirect in one Report. It works perfectly on the
machine that has Access installed.

Packaged the Dbase for a machine that doesn't have Access using "Package and
Deployment Wizard" for a run-time version.

The text S T R E T C H E D width wise and flowed past the height of the
Control.

Anyone have a suggestion, (Stephen)?

Andy

Don't expect anyone to finish my code for me but have included the code in
case someone else could use it.

The VBA code is:

Option Compare Database
Option Explicit
Dim Justi1 As New clsJustifyText

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim intFS As Integer

For intFS = 14 To 10 Step -1
Me.txtProdDescript.FontSize = intFS

If fTextHeight(Me.txtProdDescript) < Me.txtProdDescript.Height Then Exit
For
Next intFS
End Sub

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

Call Justi1.fRecordDetail(Me, "txtProdDescript", PrintCount)

End Sub

Private Sub Report_Close()
Set Justi1 = Nothing
End Sub

Private Sub Report_Page()
Dim myBool As Boolean
myBool = Justi1.fJustiDirect(Me)

End Sub

 

[Stephen Lebans]

(Stolen from Doug)

Already answer in microsoft.public.access.reports, where you asked
the same question.

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message
to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of
us
won't have to read your post multiple times. (It also uses fewer server
resources)

I see you're using Outlook Express. Click the "Newsgroups:" label to the
left of the box containing the name of the current newsgroup. That will
open
a dialog that will let you add additional newsgroups to your post.

Note that it's generally consider to be A Bad Thing to cross-post to
more
than about 2 or 3 newsgroups. (In fact, at
http://www.microsoft.com/presspass/features/2001/Mar01/Mar27pmvp.asp
Microsoft suggests that "One group will suffice")



--

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

 

[Andy]

Stephen;

Thank You for Your reply.

Knew that Cross Posting is a bad thing. What I didn't know was about the
ability of OE to add additional groups.

The reason, not the excuse, posted in two places, is that in this DBase
JustiDirect is used in a Report, then realized where JustiDirect is normally
used is a Form.

I apologize for the mis-step.

Andy