Solved

Hide Access Subform Controls On Record By Record Basis

Posted on 2004-09-08
3
244 Views
Last Modified: 2012-05-05
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
Comment
Question by:server64
3 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 75 total points
ID: 12016845
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

The purpose of this article is to demonstrate how we can use conditional statements using Python.
When we want to run, execute or repeat a statement multiple times, a loop is necessary. This article covers the two types of loops in Python: the while loop and the for loop.
The goal of the video will be to teach the user the concept of local variables and scope. An example of a locally defined variable will be given as well as an explanation of what scope is in C++. The local variable and concept of scope will be relat…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now