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  

RTF control from lebans : Resize from content on a form instead of a report



 
 
Thread Tools Display Modes
  #1  
Old December 8th, 2005, 05:54 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default RTF control from lebans : Resize from content on a form instead of a report

All,

What would be the best way to properly resize the size of a control based
upon the Lebans RTF control on a form ?

I know it does support auto resize on a report, is there an easy way to
convert the unit used on the reports on the unit used on forms ?

Any clue which does not involve overly complex calls to DLLs :P ?

Thanks for your time,
Francois Uldry
fuldry (at) hors - la - loi dot ch
(properly replaces the bad characters by the correct one to reach me)


  #2  
Old December 8th, 2005, 11:50 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default RTF control from lebans : Resize from content on a form instead of a report

What's wrong with how resizing is accomplished in the form in the sample MDB
you downloaded?

--

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


"François Uldry" wrote in message
...
All,

What would be the best way to properly resize the size of a control based
upon the Lebans RTF control on a form ?

I know it does support auto resize on a report, is there an easy way to
convert the unit used on the reports on the unit used on forms ?

Any clue which does not involve overly complex calls to DLLs :P ?

Thanks for your time,
Francois Uldry
fuldry (at) hors - la - loi dot ch
(properly replaces the bad characters by the correct one to reach me)



  #3  
Old December 9th, 2005, 07:48 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default RTF control from lebans : Resize from content on a form instead of a report

In the A2K RTF2 Sample You mean ?

Well, on the first impression, autoresizing did not work.

After making the control smaller, it did not work.

And after checking the form's oncurrent, it did work.

BUT, why is there a scroll bar inside the control ? This is rather ugly...

OK, I stand corrected, it indeed shows the correct size, my error...

Corrected code should read though :

Dim intHeight As Integer
intHeight= Me.RTFcontrol.Object.RTFheight + 100
If intHeight 0 Then
If intHeight 32000 Then
Me.RTFcontrol.height = intHeight
Else
Me.RTFcontrol.height = 12000 ' Or more
End If
End If

Me.Section(acDetail).height = intHeight + Me.RTFcontrol.Top + 15


The + 100 allows the control not to show the lateral scrollbar.
The +15 on the detail section, allows access to show the internal border of
the control

Thanks for your time,
Take care,
Francois Uldry
fuldry (at) hors - la - loi dot ch
(properly replaces the bad characters by the correct one to reach me)

"Stephen Lebans"
wrote in message ...
What's wrong with how resizing is accomplished in the form in the sample
MDB you downloaded?

--

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


"François Uldry" wrote in message
...
All,

What would be the best way to properly resize the size of a control based
upon the Lebans RTF control on a form ?

I know it does support auto resize on a report, is there an easy way to
convert the unit used on the reports on the unit used on forms ?

Any clue which does not involve overly complex calls to DLLs :P ?

Thanks for your time,
Francois Uldry
fuldry (at) hors - la - loi dot ch
(properly replaces the bad characters by the correct one to reach me)





 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Move feild entries from form to form using global variables JackCGW General Discussion 11 November 14th, 2005 05:22 AM
Need Help In Printing Current Record in Specific Report RNUSZ@OKDPS Setting Up & Running Reports 1 May 16th, 2005 09:06 PM
Total hours from Table into Report HeatherLou1974 General Discussion 3 March 7th, 2005 08:04 PM
Still Hoping for help with a Query problem Don Sealer Using Forms 15 November 13th, 2004 06:24 AM
dlookup miaplacidus Using Forms 9 August 5th, 2004 09:16 PM


All times are GMT +1. The time now is 07:32 PM.


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