Move columns

[daveUK]

Hi

I'm creating a staff database and have a form with option buttons on, which allow users to decide which fields they wish to view.

I have used a bit of code on the reports open event, which hides the column if the option button isn't selected, but I need to move the columns so that there aren't any gaps between them.

Any ideas?

Thanks

Dave

 

[namliam]

You can move any control from the same form like so:
me.YourField.Top = 1

there are simular bottom and left properties you can set.

Regards

 

[daveUK]

Thanks namliam

Do you know if there is any way to do this dynamically? There are about 15 fields that users can choose and I don't want any gaps. I'd like all of the populated colums lines up from the left.

 

[namliam]

You can do something of a for next loop
Then see if the field is visible and add the me.yourfield.width + a small space.

I am guessing you would want the proper labels to move as well...

if you cant figure it out make a small sample and i will have a try at it...

Regards

 

[daveUK]

Thanks for the offer of looking at the database, but I've found a sample at http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb, which does exactly what I'm looking for.

Thanks anyway