Access 2003 SetValue [x].[Visible] Question

[Guest]

Hi

I am trying to make a number of control labels either visible or not visible
depending on the state of a toggle control. I have tried to combine all the
labels together as one expression but I get an error.

The SetValue expression is of the format:

Item: [Label1].[Visible] And [Label2].[Visible] And ..... etc etc
Expression: Yes

As soon as I add more than one [x].[Visible] into the expression I get the
error.

Anyone know what is the correct format?

I know there will be an Access MVP out there with a simple answer for me!

Thanks

Steve

 

[Steve Schapel]

Steve,

Sorry, you can't do it like this. You will need a separate SetValue
action for each label.

 

[Guest]

Thanks very much for that Steve! I did suspect that that might be the case,
but I also hoped that logical expressions might be allowed to avoid lengthy
macros!

Steve,

Sorry, you can't do it like this. You will need a separate SetValue
action for each label.

--
Steve Schapel, Microsoft Access MVP

Hi

I am trying to make a number of control labels either visible or not visible
depending on the state of a toggle control. I have tried to combine all the
labels together as one expression but I get an error.

The SetValue expression is of the format:

Item: [Label1].[Visible] And [Label2].[Visible] And ..... etc etc
Expression: Yes

As soon as I add more than one [x].[Visible] into the expression I get the
error.

Anyone know what is the correct format?

I know there will be an Access MVP out there with a simple answer for me!

Thanks

Steve