Hidding Table Row Only When Row above is Visible

[ousoonerjoe]

How can I have TableRow3 only appear when TableRow2 is not visible?

Your helps is always appreciated.
Thank you.

"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.

 

[xlbo]

In general you would use the inverse of the logic that makes row 2 invisible but not sure how the visible properties works on rows - how many rows altogether will here be in your table and is this just for rows 2 & 3 or for other rows as well?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[ousoonerjoe]

Both Rows are Group1 Headers. Row2 is only visible at the beginning of each group listing. I need Row3 to appear on the subsequent pages (if the group carries over to a second page) instead of Row2.

(Hope this is clearer for you.)

"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.

 

[ousoonerjoe]

Ok think i'm on to a method, but having issues figuring out exactly how to implement it.

I have created an internal variable called VisBit [Boolean]. I want to set it to TRUE when Row2 is visible. Any tips on how this can be accomplished?

thanks.

"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.

 

[xlbo]

Use the same logic as you are using to determine if row 2 is visible or not

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[ousoonerjoe]

xlbo- Thanks for your suggestions. My apologies if these seems to be a 'moving target'.

I've had to change my logic, just a bit. Visibility is set by the fact that Row2 is a Group Header, not by some value. I've had to move a couple things around. The Group Heading is named Group1.TableRow1 and the row that needs to be turned on and off is named Group2.TableRow1.

Is there a constant or variable that can be read to see if the Group Heading is visible? I tried reading the textboxes inside the row, but they still read visible while the Group is Hidden.

"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.

 

[ousoonerjoe]

OK... Here's the logic I'd like to use, but don't know how to reference the Rows properly (and the MS Help is so useful in finding this info).

I'd like to get this statement (or something similar) to work for the Hidden property of Group2.TableRow1

=IIF(Group1.TableRow1.Hidden = TRUE, FALSE, TRUE)

Any thoughts on how to make this work?

"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.