Column Order, Hidden, Name

[Eightball3]

I was wondering if someone can help me with this. I have a datasheet that allows the user to hide, sort, move etc. each column. I am attempting to generate a report dynamically based of this user customized datasheet. I am trying to figure out how to read or loop through the form controls to determine the column order, whether hidden or not, size etc. I then want to use that information to generate the report. I'm no expert with VB but I know experts are here! Can anyone direct me to an example? Thank you!

[NTC]

having a user rearrange report layout on the fly is not a feasible concept in Microsoft Access.

you might consider some other application that is more explicitly designed for this purpose & capability - and then see it it can import data from Access; which is very possible....