If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Keep Rows and Columns Together. Plz Help!
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..................XX X. 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...XX X. 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) |
#2
|
|||
|
|||
Keep Rows and Columns Together. Plz Help!
Can anyone help me with this? I KNOW YOU GUYS KNOW THIS LIKE THE BACK OF YOUR
HAND But I have no place to start. PLEASE HELP! "TKM" wrote: 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..................XX X. 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...XX X. 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) |
Thread Tools | |
Display Modes | |
|
|