Solved

Hide Access Subform Controls On Record By Record Basis

Posted on 2004-09-08
3
245 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
notReplace  challenge 53 116
sum67 challenge 35 93
SQL400 max size 5 77
what is the main difference between git clone and fetch ann pull and push commands 2 71
Windows Script Host (WSH) has been part of Windows since Windows NT4. Windows Script Host provides architecture for building dynamic scripts that consist of a core object model, scripting hosts, and scripting engines. The key components of Window…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
The viewer will learn additional member functions of the vector class. Specifically, the capacity and swap member functions will be introduced.
The viewer will be introduced to the technique of using vectors in C++. The video will cover how to define a vector, store values in the vector and retrieve data from the values stored in the vector.

911 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