Saving of hidden columns

E

Eric Blitzer

Access 2000

I have a form with a subform. certain columns on the subform are hidden. I
want the user to be able to hide/unhide columns and that selection be saved
when the user opens the application the next time. This works with a MDB but
not with a MDE. Are there other methods that will allow saving of individual
user column hidden/unhidden choices. Thes choices would change from time to
time.

Thanks
 
G

George Nicholson

One possible approach:

Create a "UserSettings" table and create records for "Form1Settings",
"Form2Settings", etc. when the user closes the form. Programatically restore
those settings when the form is opened.


HTH,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASK Field Formatting 1
VBA - exporting serial letters to single documents 0
Change macro button text when macro is invoked. 2
hidden rows, column copy-paste 0
Hiding/Unhiding Tabs 2
Unable to unhide hidden columns 3
column width in continuous form 1
Help with conditionally unhiding columns 1

Top