dynamic report width

[Guest]

I have a fixed report but want to hide various fields and shrink the width of
the report depending upon user input. Is there any easy way to do this or
will I have to use VBA to set the field format properties... left/visible at
run time

Thanks

 

[Marshall Barton]

I have a fixed report but want to hide various fields and shrink the width of
the report depending upon user input. Is there any easy way to do this or
will I have to use VBA to set the field format properties... left/visible at
run time

You will efinitely need to use VBA code to change the
properties on the fly. There are a few properties that can
not be changed at runtime. For instance, older versions of
Access did not allow the report width to be changed. You'll
have to try it to see if if you run into difficulties.