form size

Dear All

Can I Control the size of the form according to the data that it previwes??

Best Regards

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200912/1

Assuming that you're wanting to control the height of a continuous form?
The short answer is no. You can set the form's Border Style property to
'Sizable' to allow users to resize it when it is displayed. But, if you are
really determined, then my general philosophy of "you can do anything if
you're bloody-minded enough" can be put into action. No detail, but the
approach would be:
Determine how many records are to be displayed (via
Me.RecordsetClone.RecordCount)
Calculate how big your form would need to be to display that many
records
In the form's Load event (the Open event will be too early), run code
using the DoCmd.MoveSize method to resize the form

You might also want to limit the size so that the form doesn't get too big
for the screen.

Have fun,

Rob



ashraf_al_ani via AccessMonster.com wrote:
Dear All

Can I Control the size of the form according to the data that it
previwes??

Best Regards