printing data from form / report

[qwertyjjj]

After having designed a series of forms, I have just been told that users would like to occasionally print the data.
On testing this, it seems that the data does not print onto 1 page.
Are there any settings to fit data to 1 page wide only?

Aternatively, is there a better way of doing this? Perhaps by using a report or something like that?
The form has a whole load of calculated fields (calculated control boxes with expressions) so would I run into any problems doing it ths way ?

Thanks.

 

[genghis82]

ahh a real problem all the time. The number of times I've pulled my hair out over this. I find that this is usually a result of pulling a control to far to the side. You can try to make the page more narrow and change the page/column widths as well. If anyone has any code that could resizes the page I would be most interested.

 

[Ron_dK]

I would suggest to make a report1 which is based on the same query/calc data as the form1. Reports are easy to handle in terms of lay out for prints etc.
On form1 , make a button which prints report1 when requested.

Hth