View Full Version : Column on Sub-form visible/invisble


MarionD
02-06-2001, 12:02 PM
Hi there,
How can I, (in VBA), change a column on a datasheet sub form to visible / invisible by clicking on a button in the Parent form?

Thanks for any help!

pdx_man
02-06-2001, 12:27 PM
Under Help, check out the ColumnHidden property. Here's a quick example:

Private Sub Command19_Click()

Me![Table1 subform].Form![Field1].ColumnHidden = True

End Sub

MarionD
02-06-2001, 10:56 PM
Thanks so much! I'm working on a German Version - Have been looking for ColumnWidth ColumnVisible etc... just couldn't hit on the right word! Thanks again!
Marion
Knittlingen, Germany