ACCESS 2007: Is there any way to keep columns in datasheet to remain hidden at all times?

Hi

Is there any way I can keep hidden columns in a datasheet hidden at all times from the user? If so, how do I do that? Certain columns are not meant for human eyes.

Thanks
PBLackAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Dale FyeConnect With a Mentor Commented:
You should be able to keep the fields in the recordsource of the form, just don't put controls for that field on the form.  Then use code to reference the value of the fields that are in the recordsource, but not displayed on the form.

If you need certain users to see those fields, and others not, then create two different datasheet forms, one with the field(s), the other without.
0
 
Dale FyeCommented:
Create a datasheet form, based on your table/query and don't include that field on the form.
0
 
PBLackAuthor Commented:
The problem with that solution is that I need those hidden columns to populate another form. I would have built it into the original design but the user wants certain stuff kept from certain eyes but wants the calculations based on the contents of hidden columns to populate another form.
0
 
PBLackAuthor Commented:
Great idea.

Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.