Keep rows and columns in sequence

G

Guest

I have several Rows and Columns. I have each row become visible if a check is
placed in an option box. If an entire row is not visable (no matter what row
it may be). how do I get the rows under it to take its place so there is no
blank rows.

Example:

.........Column 1.......Column 2............Column 3

1........XXX..............XXXX..................XXX.

2---If no check in check box then move row 3 into this spot so it is not
blank!

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

Jeff Boyce

You posted your question in a newsgroup dedicated to MS Access queries.
Your question seems to be about forms. Consider reposting to the forms
newsgroups.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
G

Guest

Jeff,

Actually it is for a report that I need this does so I will go there. Thanks
again!

Jeff Boyce said:
You posted your question in a newsgroup dedicated to MS Access queries.
Your question seems to be about forms. Consider reposting to the forms
newsgroups.

Regards

Jeff Boyce
Microsoft Office/Access MVP

TKM said:
I have several Rows and Columns. I have each row become visible if a check
is
placed in an option box. If an entire row is not visable (no matter what
row
it may be). how do I get the rows under it to take its place so there is
no
blank rows.

Example:

........Column 1.......Column 2............Column 3

1........XXX..............XXXX..................XXX.

2---If no check in check box then move row 3 into this spot so it is not
blank!

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)
Click to expand...
Click to expand...
 
G

Guest

Jeff,

Noboday seems to be able to help me with this. Can you elaborate just a
little more so I understand what I need to do to get this to work. I am in
kind of a bind. Like everyone else I suppose. Thanks a Million!

Jeff Boyce said:
You posted your question in a newsgroup dedicated to MS Access queries.
Your question seems to be about forms. Consider reposting to the forms
newsgroups.

Regards

Jeff Boyce
Microsoft Office/Access MVP

TKM said:
I have several Rows and Columns. I have each row become visible if a check
is
placed in an option box. If an entire row is not visable (no matter what
row
it may be). how do I get the rows under it to take its place so there is
no
blank rows.

Example:

........Column 1.......Column 2............Column 3

1........XXX..............XXXX..................XXX.

2---If no check in check box then move row 3 into this spot so it is not
blank!

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)
Click to expand...
Click to expand...
 
G

Guest

Post the SQL of the query used as source for the report by opening in design
view, click on menu VIEW - SQL View, highlight all, copy and paste in a post.
--
KARL DEWEY
Build a little - Test a little


TKM said:
Jeff,

Noboday seems to be able to help me with this. Can you elaborate just a
little more so I understand what I need to do to get this to work. I am in
kind of a bind. Like everyone else I suppose. Thanks a Million!

Jeff Boyce said:
You posted your question in a newsgroup dedicated to MS Access queries.
Your question seems to be about forms. Consider reposting to the forms
newsgroups.

Regards

Jeff Boyce
Microsoft Office/Access MVP

TKM said:
I have several Rows and Columns. I have each row become visible if a check
is
placed in an option box. If an entire row is not visable (no matter what
row
it may be). how do I get the rows under it to take its place so there is
no
blank rows.

Example:

........Column 1.......Column 2............Column 3

1........XXX..............XXXX..................XXX.

2---If no check in check box then move row 3 into this spot so it is not
blank!

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)
Click to expand...
Click to expand...
Click to expand...
 
J

Jeff Boyce

Bear in mind that the folks here are volunteers. It may take a minute or an
hour or a day or ?! for someone with both the time and an idea...

If you are saying that you can have controls on your report that have Null,
you could use the CanGrow & CanShrink properties of the control AND the
section in which the control is placed.

Regards

Jeff Boyce
Microsoft Office/Access MVP

TKM said:
Jeff,

Noboday seems to be able to help me with this. Can you elaborate just a
little more so I understand what I need to do to get this to work. I am in
kind of a bind. Like everyone else I suppose. Thanks a Million!

Jeff Boyce said:
You posted your question in a newsgroup dedicated to MS Access queries.
Your question seems to be about forms. Consider reposting to the forms
newsgroups.

Regards

Jeff Boyce
Microsoft Office/Access MVP

TKM said:
I have several Rows and Columns. I have each row become visible if a
check
is
placed in an option box. If an entire row is not visable (no matter
what
row
it may be). how do I get the rows under it to take its place so there
is
no
blank rows.

Example:

........Column 1.......Column 2............Column 3

1........XXX..............XXXX..................XXX.

2---If no check in check box then move row 3 into this spot so it is
not
blank!

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)
Click to expand...
Click to expand...
Click to expand...
 

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 Together. Plz Help! 1
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Input specific value into cell if Row has data 3
Time punch data from rows to columns 3
Word 2002: How to add empty rows to numbering ? 2
Multiple Columns on a Report 1
Excel Match two columns/rows within multiple sheets then paste answer... 0
Basic code condense question 2

Top