How to make a datasheet column invisible.
Q: Mary H. has a datasheet column that is needed for doing calculations, but she doesn’t want it to show. She set its Visible property to No, but it still appears in datasheet view. How can the column be made invisible?
A: The Visible property doesn’t work to make a datasheet column invisible. You can use the ColumnHidden property instead, from the Form_Current event, as in this line of code:
Me![txtSubtotal].ColumnHidden = True
