Dynamic Report

[matethreat]

Hello,

I am trying to create a report that moves text boxes depending on what is selected on a form.

Details:

I have a form with 18 check boxes. These check boxes represent an item that can be visible on a report.

I have no trouble setting up the report to make items visible or not if the check box is selected.

What I would like to be able to do is if a item is not meant to be visible, every text box to the right of it moves over so I don't have gaps. This is relatively simple for a few text boxes but with 18 it becomes extremly cumbersome, especially if the ones that don't want to be seen are spread out.

Can anyone think of a compact way of coding this.

Destiny Is Not The Chances We Take, But The Descisions We Make.

 

[dhookom]

You should think about naming your controls like txt1, txt2, txt3,.. so that you can set up some type of loop in code. You need to write some pseudo code based on how you would do this manually. Once you have figured out the logic, someone can help with the coding.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[matethreat]

I have actually figured out how to do it. It took some persistance and head scratching.

Thank You

Destiny Is Not The Chances We Take, But The Descisions We Make.