Re: Detail Height
- From: "Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@xxxxxxxxxxxx>
- Date: Tue, 27 Dec 2005 01:06:03 -0400
I realize english is not your native language but I can almost understand
what you are trying to accomplish. Could you take a minute repost and
explain in detail exactly what you are trying to accomplish. Forget about
your code for now and focus on what the results are you are looking for.
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Jemsson" <Jemsson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A1244E2D-A314-47ED-812B-E056E00FFF18@xxxxxxxxxxxxxxxx
> Hello
>
> I have report that I use print by VB Event / on Format
>
> Well, When I print so some post have more than 1 raw and that make problem
> with Detail Height, cause Detail know ONLY data on TextBox.
> So I made empty TextBox with name: CanGrow
>
> I try to make own code and it works, but the problem is:
> Slowly and the other problem is the result of Height shows on next post
> instead on current post!
>
> ----------------------
> Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
> Dim Number, Words, TheRaw As Integer
>
> TheRaw = 0
> Number = Len(strLast) 'strLast data coms from VB print
>
> For Words = 1 To Number Step 1
> If Left(Mid(strLast, Words), 1) = vbCr Then
> TheRaw = TheRaw + 1
> End If
> Next Words
>
> If Not TheRaw = 0 Then
> Me.txtGrow.Height = 500 * TheRaw
> End If
> End Sub
> -----------------------
>
> I know this code I created is not the best, because it take long time when
> open report.
>
> Do you have any idée to calculate how many VbCr and then make
> Me.TextGrow.Hieght = ... on only current post ?
>
> So In this TextGrow.Height will give enough space on Detail to show that
> "strLast" that prints direct from VB on report.
>
> Lots of thanks for giving your time and read my question
.
- Follow-Ups:
- Re: Detail Height
- From: Jemsson
- Re: Detail Height
- Prev by Date: Re: Ole Object Not Printing
- Next by Date: Re: Summarizing records in one table that match a different table
- Previous by thread: Re: Summarizing records in one table that match a different table
- Next by thread: Re: Detail Height
- Index(es):
Relevant Pages
|
