Access 2003 SetValue [x].[Visible] Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,

Sorry, you can't do it like this. You will need a separate SetValue
action for each label.
 
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 Schapel said:
Steve,

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

--
Steve Schapel, Microsoft Access MVP

Steve said:
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
Click to expand...
Click to expand...
 
Back
Top