Report Width - Scaling dynamically

[RonL]

I'm new to report design, and have a test report fashioned in design view. Each detail line has three text boxes. The goal is to permit the user to choose one of several report widths without changing the page size. IOW, we're aiming for flexibility in the margins but within the context of a fixed piece of paper - ie. a single printer tray. (The rept is a list of tasks for camera operators, each of whom will attach it to his equipment per personal preference. So each wants a particular width he can "cut out" of a standard page.)



As a preliminary test, I tried halving the width property in design view. But Access won't let me. The value springs back to just below 8". I assume this limitation is being imposed by the cumulative width of the controls in the report. Correct? If so, my question is: is there a way to scale the entire report width without adjusting the individual control widths? If so, I'd appreciate a pointer to the appropriate, VBA accessible properties.

Thank you. -Ron

[June7]

Yes, report width must accommodate cumulative width of controls. I believe the answer to the scaling question is No.

[RuralGuy]

I believe some printer drivers support "Fit to Page".

[RonL]

I believe some printer drivers support "Fit to Page".

Right. I was hoping for a simple scaling solution that I could implement with VBA and that would be printer independent. There do seem to be some relevant properties, report.scalewidth and report.scalemode (Access 2010), but apparently not accessible from the report property sheet, and I'm not about to attempt manipulating properties in code that I don't understand.

I may have to design separate reports.

Thx to you both. -Ron

[June7]

I checked out those properties and don't think they would do what you want anyway.

[RonL]

I did brief search & got same impression. Thx for confirming! -Ron