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 » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

A97 and report RTF2 Llebans



 
 
Thread Tools Display Modes
  #1  
Old August 17th, 2006, 02:36 PM posted to microsoft.public.access.forms
A.C.
external usenet poster
 
Posts: 21
Default A97 and report RTF2 Llebans

I use the RTF2 Lebans in the form is OK, but in report whit Access 97 is
very big problem.
The source code post in the example by leban's website don't work with A97,
because it don't support the set of detail section.
How is possible make report with more page with A97 ?

Than you
alessandro


  #2  
Old August 18th, 2006, 03:57 AM posted to microsoft.public.access.forms
Stephen Lebans
external usenet poster
 
Posts: 619
Default A97 and report RTF2 Llebans

Technically you cannot. This is explained, along with a partial possible
solution for A97 he
http://www.fmsinc.com/faqs/tamemo.htm#2000GrowShrink

--

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


"A.C." wrote in message
...
I use the RTF2 Lebans in the form is OK, but in report whit Access 97 is
very big problem.
The source code post in the example by leban's website don't work with
A97, because it don't support the set of detail section.
How is possible make report with more page with A97 ?

Than you
alessandro



  #3  
Old August 19th, 2006, 03:12 PM posted to microsoft.public.access.forms
A.C.
external usenet poster
 
Posts: 21
Default A97 and report RTF2 Llebans

i know the fms and i have also the demo but RTF2 haven't the prop.
HeightOfText

"Stephen Lebans"
ha scritto nel messaggio ...
Technically you cannot. This is explained, along with a partial possible
solution for A97 he
http://www.fmsinc.com/faqs/tamemo.htm#2000GrowShrink

--

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


"A.C." wrote in message
...
I use the RTF2 Lebans in the form is OK, but in report whit Access 97 is
very big problem.
The source code post in the example by leban's website don't work with
A97, because it don't support the set of detail section.
How is possible make report with more page with A97 ?

Than you
alessandro





  #4  
Old August 20th, 2006, 02:12 AM posted to microsoft.public.access.forms
Stephen Lebans
external usenet poster
 
Posts: 619
Default A97 and report RTF2 Llebans

Did you even bother to look at:
1) The RTF2 Web page.
2) The code behind the Forms and Reports in the sample RTF2 MDB you
downloaded.

The property you are looking for is named "RTFheight".

--

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


"A.C." wrote in message
...
i know the fms and i have also the demo but RTF2 haven't the prop.
HeightOfText

"Stephen Lebans"
ha scritto nel messaggio ...
Technically you cannot. This is explained, along with a partial possible
solution for A97 he
http://www.fmsinc.com/faqs/tamemo.htm#2000GrowShrink

--

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


"A.C." wrote in message
...
I use the RTF2 Lebans in the form is OK, but in report whit Access 97 is
very big problem.
The source code post in the example by leban's website don't work with
A97, because it don't support the set of detail section.
How is possible make report with more page with A97 ?

Than you
alessandro







  #5  
Old August 20th, 2006, 05:13 PM posted to microsoft.public.access.forms
A.C.
external usenet poster
 
Posts: 21
Default A97 and report RTF2 Llebans

Ok. i have make an example with the same table and the same code-report, one
with fms and one with RTF2.
With Fms is Ok, RTF2 no. I debud code, the problem is that the prop.
heightoftext return 60960 (the max of multipage for the record select) and
rtf2 -6016. This because, i think, the RTF2Height is integer and not long.
If this right, is possible change ocx prop?

thank you
alessandro
"Stephen Lebans"
ha scritto nel messaggio ...
Did you even bother to look at:
1) The RTF2 Web page.
2) The code behind the Forms and Reports in the sample RTF2 MDB you
downloaded.

The property you are looking for is named "RTFheight".

--

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


"A.C." wrote in message
...
i know the fms and i have also the demo but RTF2 haven't the prop.
HeightOfText

"Stephen Lebans"
ha scritto nel
messaggio ...
Technically you cannot. This is explained, along with a partial possible
solution for A97 he
http://www.fmsinc.com/faqs/tamemo.htm#2000GrowShrink

--

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


"A.C." wrote in message
...
I use the RTF2 Lebans in the form is OK, but in report whit Access 97 is
very big problem.
The source code post in the example by leban's website don't work with
A97, because it don't support the set of detail section.
How is possible make report with more page with A97 ?

Than you
alessandro









  #6  
Old August 21st, 2006, 02:13 AM posted to microsoft.public.access.forms
Stephen Lebans
external usenet poster
 
Posts: 619
Default A97 and report RTF2 Llebans

The property is typed as Integer because 32K is the max value you can apply
to a TextBox or Section Height property.

--

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


"A.C." wrote in message
...
Ok. i have make an example with the same table and the same code-report,
one with fms and one with RTF2.
With Fms is Ok, RTF2 no. I debud code, the problem is that the prop.
heightoftext return 60960 (the max of multipage for the record select) and
rtf2 -6016. This because, i think, the RTF2Height is integer and not long.
If this right, is possible change ocx prop?

thank you
alessandro
"Stephen Lebans"
ha scritto nel messaggio ...
Did you even bother to look at:
1) The RTF2 Web page.
2) The code behind the Forms and Reports in the sample RTF2 MDB you
downloaded.

The property you are looking for is named "RTFheight".

--

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


"A.C." wrote in message
...
i know the fms and i have also the demo but RTF2 haven't the prop.
HeightOfText

"Stephen Lebans"
ha scritto nel
messaggio ...
Technically you cannot. This is explained, along with a partial
possible solution for A97 he
http://www.fmsinc.com/faqs/tamemo.htm#2000GrowShrink

--

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


"A.C." wrote in message
...
I use the RTF2 Lebans in the form is OK, but in report whit Access 97
is very big problem.
The source code post in the example by leban's website don't work with
A97, because it don't support the set of detail section.
How is possible make report with more page with A97 ?

Than you
alessandro











  #7  
Old August 23rd, 2006, 01:54 PM posted to microsoft.public.access.forms
A.C.
external usenet poster
 
Posts: 21
Default A97 and report RTF2 Llebans

The height of text depend of image, font, fontsize ecc, (also only text can
be big then 32k) then is possible have memofield big then 32k and RTF2 prop.
height return a negative value. So, if change the prop. return a break.
I found a solution change the sample mdb RTF00_1_5_97 in the web page (with
big memo break).
So, post the code:

Private Sub Detail1_Format(Cancel As Integer, FormatCount As Integer)
' 1440 twips x 22 inch =31680
Const MAXsizeheight = 31680

Dim intHeight As Integer
Dim strText As String

' Check for the text in the control
strText = Me.tamDemo.Object.PlainText
If Trim(strText) = "" Then
Me.ctlrtf.Height = 0
Else

' Retrieve height
intHeight = Me!ctlrtf.RTFheight
If intHeight 0 Then
intHeight = MAXsizeheight
End If


If Me!ctlrtf.Top + intHeight MAXsizeheight Then
intHeight = MAXsizeheight - Me!ctlrtf.Top
End If


Me!ctlrtf.Height = intHeight
End If
end sub

Now, it don't break. The only problem print only 2 page and half. Is there a
solution ?


"Stephen Lebans"
ha scritto nel messaggio ...
The property is typed as Integer because 32K is the max value you can
apply to a TextBox or Section Height property.

--

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


"A.C." wrote in message
...
Ok. i have make an example with the same table and the same code-report,
one with fms and one with RTF2.
With Fms is Ok, RTF2 no. I debud code, the problem is that the prop.
heightoftext return 60960 (the max of multipage for the record select)
and rtf2 -6016. This because, i think, the RTF2Height is integer and not
long.
If this right, is possible change ocx prop?

thank you
alessandro
"Stephen Lebans"
ha scritto nel
messaggio ...
Did you even bother to look at:
1) The RTF2 Web page.
2) The code behind the Forms and Reports in the sample RTF2 MDB you
downloaded.

The property you are looking for is named "RTFheight".

--

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


"A.C." wrote in message
...
i know the fms and i have also the demo but RTF2 haven't the prop.
HeightOfText

"Stephen Lebans"
ha scritto
nel messaggio ...
Technically you cannot. This is explained, along with a partial
possible solution for A97 he
http://www.fmsinc.com/faqs/tamemo.htm#2000GrowShrink

--

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


"A.C." wrote in message
...
I use the RTF2 Lebans in the form is OK, but in report whit Access 97
is very big problem.
The source code post in the example by leban's website don't work
with A97, because it don't support the set of detail section.
How is possible make report with more page with A97 ?

Than you
alessandro













 




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


All times are GMT +1. The time now is 08:40 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.