Hi Tim,
As Rick mentioned, in continues view the property is for all the "controls"
on the form view, once we set any property, each "control" on the form
changes accordingly; Access stores a single set of property settings for
each control on the form. The possible workaround could be using
conditional format, customize the main form's color (such as backgroup,
border style, etc) to be the same as the control's, this way we simulate
the effects for hiding the control for each record (simulating the visible
property), however, it seems conditional formatting does not apply to Label
controls.
ACC2000: Changing Control Properties Affects All Records in Form
http://support.microsoft.com/support/kb/articles/q208/9/61.asp
You may want to submit a wish for the feature via the web site:
http://register.microsoft.com/mswish/suggestion.asp
Please feel free to reply to the threads if you have any concerns.
Sincerely,
Alick Ye, MCSD
Microsoft Online Partner Support
Get Secure! -
www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Tim J" <
[email protected]>
| X-Tomcat-NG: microsoft.public.access.formscoding
|
| I have some code in On Open event which sets certain
| controls and labels to be visible based on the record.
|
| The form is set to continous.
|
| The problem I have is the visible labels and controls is
| identical for each record and it shouldn't be. The code
| is running for only the data in the first record.
|
|
| Have can I have the code run for each individual record in
| continous view?
|
| TIA,
| Tim J
|
