T
TKM
I have several Rows and Columns that become visible if a check is
placed in an option box. If no chek is placed then the entire row is not
visible. However I would like the row or Rows under it to move up and take is
place. See below.
Example:
..............Column 1.......Column 2............Column 3
Row 1........XXX..............XXXX..................XXX.
Row 2---If no check in check box then move row 3 into this spot so it is not
blank!
Row 3.........XXX..............XXX..............r...XXX.
Here is what the code looks like to make the rows or fields visible..
'Below is fired via the optionbox IsDisplayIncome
Me.[OneMileIncome].Visible = Nz(Me.[IsDisplayIncome], True)
Me.[ThreeMileIncome].Visible = Nz(Me.[IsDisplayIncome], True)
Me.[FiveMileIncome].Visible = Nz(Me.[IsDisplayIncome], True)
placed in an option box. If no chek is placed then the entire row is not
visible. However I would like the row or Rows under it to move up and take is
place. See below.
Example:
..............Column 1.......Column 2............Column 3
Row 1........XXX..............XXXX..................XXX.
Row 2---If no check in check box then move row 3 into this spot so it is not
blank!
Row 3.........XXX..............XXX..............r...XXX.
Here is what the code looks like to make the rows or fields visible..
'Below is fired via the optionbox IsDisplayIncome
Me.[OneMileIncome].Visible = Nz(Me.[IsDisplayIncome], True)
Me.[ThreeMileIncome].Visible = Nz(Me.[IsDisplayIncome], True)
Me.[FiveMileIncome].Visible = Nz(Me.[IsDisplayIncome], True)