Keep Rows and Columns Together. Plz Help!

G

Guest

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)
 
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keep rows and columns in sequence 5
Multiple Columns on a Report 1
Move Rows up to Blank Area. Plz Help 14
Reports Columns Help/Field Name Help 3
Resize columns on report to match form and move columns left toremove gaps 1
Basic code condense question 2
Word 2002: How to add empty rows to numbering ? 2
Time punch data from rows to columns 3

Top