Keep rows and columns in sequence

[TKM]

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)

 

[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

 

[TKM]

Jeff,

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

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

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)

 

[TKM]

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!

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

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)

 

[KARL DEWEY]

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

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!

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

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)

 

[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

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!

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

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)