>Is there away to automatically get foxpro to shrink the size of the report output if you change the paper size for example changing to letter from A4 when selecting properties? Or do I have to design a report for printing to A4 and one to printing to letter or what ever size I need?
>
>Thanks in advance

I don't use the report engine which comes with VFP9, I use Rich Simpson's Mind's Eye Report Engine which has this feature. It's not cheap, but It's absolutely worth the price if you need some of all the extra features. http://www.mindseyeinc.com/ReportEngine/index.htm