stacked textboxes problem

  • Thread starter Thread starter Mon
  • Start date Start date
M

Mon

Hi All I have three text boxes stacked on top of each
other with a "Case" routine to make them visible true or
false. (On a continuous form view). when I move to the
next record- if a different textbox is used, in the
previous record the data then disappears. How can I make
the previous data stay visible?
Thanks Mon
 
Mon,

You can't do this with a vba procedure. A change to the control's
Visible property will apply to all records in the form.

It is difficult to give more precise advice, without knowing more
about the data and what you are really trying to achieve. It may be
applicable to use a calculated field in the query that the form is
based on, to manipulate which data is returned on the form.

- Steve Schapel, Microsoft Access MVP
 
Thanks Steve, I thought it would be a problem (one of
these impossible dreams) Instead of using a contimuous
form I have used a single form view and that is OK because
the previous records are not viewed (more that one way to
skin a cat, eh???)
thanks again
Mon
 
If you are doing this in Access 2000 or later, you might be able to manage
it with conditional formatting. I'm not sure, because the usual tricks
won't quite do what you're trying to do. Disabling the control doesn't make
it invisible. Setting the colors on the control to be the same as the
background will also obscure the "active" box. I don't think there's a way
to set a control transparent, or use Bring to Front/Send to Back with
conditional formatting.

If anybody could pull this off, though, Stephen Lebans is the man. You
might want to wander over to his site (www.lebans.com) and see if you can
get some ideas.

HTH,

Marshall Smith
Project Developers, Inc.
 
I have run into problems with multiple stacked textbox controls and CF
whereby Access will get into an infinite loop when processing the CF
conditions.
There are some samples showing how to hide the text of the control to
simulate a Visible CF prop here:
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.
 
Back
Top