How to unhide columns in the query

[HLPCH]

I have a query which is run by couple of users. some of them would hide certain fields before exporting it to excel. When they close the query the fields do not unhide themselves and next time when the users logs in they are not able to see all the fields.

Is there anyway i could prevent someone from hiding the fields or have some code behind the form to unhide all fiels before they close the query?

Thanks in advance!

 

[lupins46]

You can set the query properties to OutputAllFields = Yes.
This means that all fields will always be output irrespective of what is shown in the grid.
However if you want your users to be able to select some fields then I suggest that give them a query of their own to play with and not a query which matters to the application.