Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • Last Modified:

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
0
PBLack
Asked:
PBLack
  • 2
  • 2
1 Solution
 
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
 
Dale FyeCommented:
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
 
PBLackAuthor Commented:
Great idea.

Thanks!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now