Visible Control on Continuous Form

[Max]

Acc 2K. Have a Yes/No control (based on a field) on a
continuous form. If the value is Yes, I want another
control (also based on a field) to become visible for that
record ONLY. It becomes visible for all records. I have
the code in the OnCurrent event. Any way around this
problem?
Thanks in advance.
Max

 

[Ken Snell [MVP]]

No, not directly. Controls on a continuous forms view are actually the same
control for each record; just displayed many times. Thus, what you have on
one record will be there for all the records.

You might be able to use Conditional Formatting to change the background
color of a control that would make it "appear visible" if you change from
the default color of the background to some other color (have no borders on
it, of course) -- but this is limited in capability especially if you want
to make a command button visible, for example. You also can use Conditional
Formatting to enable/disable a control, and this may be another possible
workaround.

 

[Stephen Lebans]

There is a sample on my site showing how to accomplish what you
described Ken.
http://www.lebans.com/conditionalformatting.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Ken Snell [MVP]]

Thanks, Stephen. I'll add this to my library of links.