please help - hide control and control header with conditionalformatting

[Rick]

good morning,

i am in need of some help with a form i have built. everything works
perfectly except for one thing. when a condition has been met within
the form, i want to be able to hide certain controls and their control
headers automatically. i have been unsuccessful in hiding both the
control and control header, as i can only seem to hide the control.
any information would be greatly appreciated!


thank you,


rick

 

[Rick]

i was able to successfully hide the control and control header through
the use of a repeating section. but now i have a new problem and
could definitely use some expertise to help...

i have created a repeating table that has a drop down to show expense
type and three subsequent columns for previous amount, change amount
and total. i have also added a footer to the repeating table to sum
each of the columns. the formula i used to autopopulate the footer
text boxes with the sum of the repeating table rows is :
sum_previous_Amount: sum(@previous_Amount). My data is linked via an
Access database.

the problem is that the function only sums the first row. any added
rows within the repeating table are not captured as part of the sum.
i followed microsoft's directions to sum the columns, so i'm at a
loss. any help would be greatly appreciated!!!

rick

 

[Ravi G]

Hi Rick,

You can also hide the header by keeping header in a expression box and write
the same condition(the condition you wrote for control) to this expression
box.