Formatting a report................

[Chris1977]

Hey Folks,

Right now i have a report with multiple fields. I have check boxes tied to these fields so that if the check box is checked the enabled property of the field on the report changes to false. This works fine.

The problem i'm having is that if i hide a field in the middle of the report then print it i have this gaping hole........it looks riduclous.

What i want to know is if there is a way to auto format this report thus moving the fields on the report into a logical order once one of them has been hidden. Is there a way to have the columns move together to eliminate the hole created by hiding a field?

Any help would be greatly appreciated.

Thanks,
Chris

 

[DonQuichote]

If you know how to program in VBA, you can use the onFormat event.
What I do sometimes (I don't think it will work with checkboxes though) is making a control very small in height and set the "can grow" property to true.

Best regards

 

[Chris1977]

Thanks for the response.

In vba is there a way to set the location of a control on an access report to fit into a certain area of the screen.......such as setting a photo on a website to be at a certain area of the screen based on pixel placement. If there is a way to do this my problems are solved.

Thanks