Scale Printing to one page width

[jon_v10]

I need to develop a piece of coding that will scale the printing of Access Table's or Queries to one page width.

This is simple to do within Excel, the following can be used:

.FitToPagesWide = 1

however, Access does not offer such an option. Does anybody have any ideas how to achieve this in Access?

Thanks

 

[IfButOnly]

jon, you have an option for report printing which may be applicable for what you are trying.

stDocName = "rptClientSelect"
DoCmd.OpenReport stDocName, acPreview, , prtSQL
DoCmd.RunCommand acCmdZoom75

Check out help on the acCmdZoom and see if it has what you want.

 

[Rich]

There is no fit to page option in access as you've already discovered, there is however sample code to re-size the font of a textbox based on the string length.