Hiding controls per record on continuous form

[George Avery]

Hello all,

I\'d appreciate any pointers to the best way to resolve my issue.

I have a form which display additional controls only when one of the
controls contains a certain value. I used -

If Me.Control_Name = \"Certain Value\" Then
Me.Other_Control.Visible = True
etc.
etc.
Else
Me.Other_Control.Visible = False
etc.
etc.
End If

It worked great until my users wanted to view multiple records
simultaneously. I changed to a continuous form and now if any one of the
records display the value that causes the additional ones to appear, then
all the records display the additional controls.

I can see why this is as it\'s a single form but I wonder if there is an
easy way to display the additional stuff only on those records where it\'s
needed.

t.i.a. - GA

[John Spencer]

No way to do that. All the rows have to have the same controls in the same
state of visibility.

One option show the controls, but use conditional formatting to enable/disable
them or to change the font color to match the background color. You could
also use the current event to unlock/lock the controls as appropriate.

Another option, is to show the records in a continuous form without the
controls you want to show/hide in the detail section. This is used to choose
the current record. In the footer you can place all the controls for editing
the data. (I just place a large transparent button over the detail section to
capture any clicks)

Another option display all the records in a listbox on a single form and then
use a listbox after update event to move to the desired record.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Post by George Avery
Hello all,
I\'d appreciate any pointers to the best way to resolve my issue.
I have a form which display additional controls only when one of the
controls contains a certain value. I used -
If Me.Control_Name = \"Certain Value\" Then
Me.Other_Control.Visible = True
etc.
etc.
Else
Me.Other_Control.Visible = False
etc.
etc.
End If
It worked great until my users wanted to view multiple records
simultaneously. I changed to a continuous form and now if any one of the
records display the value that causes the additional ones to appear, then
all the records display the additional controls.
I can see why this is as it\'s a single form but I wonder if there is an
easy way to display the additional stuff only on those records where it\'s
needed.
t.i.a. - GA

[George Avery]

Many thanks for that John. I'll have to do some experimenting when I'm
back at work tomorrow. Just enabling/disabling the controls sounds
like my best option - I have to keep it simple :^)

GA
On Wed, 15 Jun 2011 09:21:49 -0400, John Spencer

Post by John Spencer
No way to do that. All the rows have to have the same controls in the same
state of visibility.
One option show the controls, but use conditional formatting to enable/disable
them or to change the font color to match the background color. You could
also use the current event to unlock/lock the controls as appropriate.
Another option, is to show the records in a continuous form without the
controls you want to show/hide in the detail section. This is used to choose
the current record. In the footer you can place all the controls for editing
the data. (I just place a large transparent button over the detail section to
capture any clicks)
Another option display all the records in a listbox on a single form and then
use a listbox after update event to move to the desired record.
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Post by George Avery
Hello all,
I\'d appreciate any pointers to the best way to resolve my issue.
I have a form which display additional controls only when one of the
controls contains a certain value. I used -
If Me.Control_Name = \"Certain Value\" Then
Me.Other_Control.Visible = True
etc.
etc.
Else
Me.Other_Control.Visible = False
etc.
etc.
End If
It worked great until my users wanted to view multiple records
simultaneously. I changed to a continuous form and now if any one of the
records display the value that causes the additional ones to appear, then
all the records display the additional controls.
I can see why this is as it\'s a single form but I wonder if there is an
easy way to display the additional stuff only on those records where it\'s
needed.
t.i.a. - GA