report scaling

[KulasCage]

is there a feature in MSAccess 97 to rescale the print area like in MSExcel. I'v got problem in printing of my report, I cannot fit all my fields.

thanks

 

[Rich]

Put simply no. You'll have to manually change the textbox/font sizes etc

 

[KulasCage]

I'm only using arial 8, and i beleive the smallest i got here.
mmm.. i'm thinking of dowloading small fonts maybe that's the only soluion.

thanks for your advise.

 

[Rich]

Will changing to landscape help?

 

[KulasCage]

well, i did that also, but i have 15 fields mostly text.

 

[doss]

Hello.

You can actually get font sizes smaller than what is available on the dropdown list. Just type it in and press enter.

I found that arial 6 is about as small as you can get and still read it, though it's hard to read when the report is in design mode. You can read it when it's printed......see attachment.

Hope that helps...

 

[KulasCage]

ah ok.....i'd never try that....maybe that's the best solution.

thanks doss.