Hiding columns on datasheet subform - need help asap!

[BigMrC]

I have a subform on a form which is displayed in datasheet view. I want
certain columns of this subform hidden depending on whether a password
has been entered on the main screen.
Failing that, even to hide the data by making it invisible or
something.
How do I program that in?
thanks

 

[Pavel Romashkin]

Either use another subform for the same subform frame of the main form,
or change the record source to a query not providing valid data for
confidential fields.

Pavel