Hide column problem

[syntaktik]

I have a split form where I have an option group. In the frame i have 3 buttons. One button displays all columns, while the others remove some. The problem is I can get the columns to hide with this Code:

Me.Controls("field").ColumnHidden = True

But, I have to click design view, and then form view to see the change. Or open and close the form. How do i apply the changes with out doing that?

 

[syntaktik]

I tried all of these:

   Me.Refresh
   Me.Requery
   Me.Repaint

None seem to work.

 

[SpiritedAway]

I have a "hide" button with an embedded macro - the action is RunCommand and Argument is UnhideColumns. It displays a dialog box with all the columns in my split form and I tick the ones I want visible and it hides the rest.

 

[syntaktik]

Well, that could be an option. However, I have around 15 columns i want to hide at a different amount. For the end user it would be an insane amount of clicking haha. But looking at it, it might seem i need to redesign the form.
I mean, my method works, but i have to switch back and forth to see the change. It has to work some way.

 

[syntaktik]

bump this thread one time.

 

[syntaktik]

one more bump.

 

[syntaktik]

And it seems no one on earth can solve this problem.