Variable layout

[GraeagleBill]

If one has a form with column headings and corresponding bound TB's beneath them and wants to have a variation of the column layout, i.e., add a column and/or suppress a column, is there an easy way to toggle between layouts when the form opens? One way of course would be to have two form definitions and open selectively. However, when there's a lot of functionality behind the form's code sheet, design principles sort of go "out the window" and maintenance of duplicate code would become a nightmare. Tabs isn't the answer with this app and its user set. Toggling of visibility depending on which version of the form is desired is one clear way of doing this in the OPEN code, but the design view would be somewhat cumbersome to say the least.



Any thoughts?

Thanks,
Bill

[John_G]

Would it be practical to use VBA to modify the column headings and the control sources of the text boxes? It might work if there not too many of them.

John

[GraeagleBill]

John,
That was my first thought. That being to have two super-imposed Column text boxes and column labels and simply set the visibility properties according to the desired version of the display. There are 10 TB's and the corresponding 10 column labels, so the design view would be tedious to deal with.

In the case of 7 of the TB's and their corresponding column labels, I'd really only have to change their x displacement within the form. While the property sheet specifies those displacements in inches, I think the code would have to set them in units of Twips?

Bill

[June7]

Yes, VBA expects TWIPS.

I do both of what you describe - turn subforms on or off as well as reposition controls. Only workable with single view form.

[GraeagleBill]

Hey June,
I'm glad you mentioned "Only workable with single view form". The form in topic here is continuous..........OUCH!
Off to bed, I'll think more about it in my dreams
Bill