Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Hide Access Subform Controls On Record By Record Basis

I am working on a subform that is pretty busy and I have been asked to make it easier to read/follow.

I was asked hide controls that did not have values in them.  I have tried looping through the controls to check for a value and then hide the control if necessary but when I hide a control it hides that control on all subform records.

Is there a way to hide a control on a subform on a record b record basis?

Thanks
0
server64
Asked:
server64
1 Solution
 
mlmccCommented:
It can be done but not if you are using the Datasheet view.  The datasheet view is simply taking the form and displaying it multiple times so changes to one "copy" of the form affect the others.

If you really need to do this then perhaps a single form view would be better.

mlmcc
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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