Eliminate the blank spaces

[qkimchi via AccessMonster.com]

Please help. Before I post this message I already read many posts that have
the same problem. I have set all my text boxes property Can Shrink and Can
Crow to "yes". Make sure my text boxes are not over lapping each other. I
also tried to put [name of field]<>Null in the filter property. however, the
blank spaces still appear on my report.
If you have other solutions to this problem. Please help me.
Thank you.
Kim

 

[Duane Hookom]

Is your section set to allowing shrinking?

 

[qkimchi via AccessMonster.com]

Yes, all sections are set to can Shrink.

Please help. Before I post this message I already read many posts that have
the same problem. I have set all my text boxes property Can Shrink and Can
Crow to "yes". Make sure my text boxes are not over lapping each other. I
also tried to put [name of field]<>Null in the filter property. however, the
blank spaces still appear on my report.
If you have other solutions to this problem. Please help me.
Thank you.
Kim

 

[Duane Hookom]

Are you also stating there are no controls (text boxes, lines, labels,...)
to the left or right of the expected shrinking text box and the value in the
text box is Null?

Try display the border of the text box and see if it shrinks as expected.

--
Duane Hookom
MS Access MVP
--

Yes, all sections are set to can Shrink.

Please help. Before I post this message I already read many posts that
have
the same problem. I have set all my text boxes property Can Shrink and
Can
Crow to "yes". Make sure my text boxes are not over lapping each other.
I
also tried to put [name of field]<>Null in the filter property. however,
the
blank spaces still appear on my report.
If you have other solutions to this problem. Please help me.
Thank you.
Kim

 

[BruceM]

To help yourself diagnose just what is happening, add background colors,
borders, shading, or some such to the text boxes. You can remove these once
the problem is solved.

Yes, all sections are set to can Shrink.

Please help. Before I post this message I already read many posts that
have
the same problem. I have set all my text boxes property Can Shrink and
Can
Crow to "yes". Make sure my text boxes are not over lapping each other.
I
also tried to put [name of field]<>Null in the filter property. however,
the
blank spaces still appear on my report.
If you have other solutions to this problem. Please help me.
Thank you.
Kim

 

[qkimchi via AccessMonster.com]

sorry but I am kind of confuse at this point. Ok, this is how my report look
like when everything is filled out.


Intervention Strategy

Medical:

Year Amount
2006 $440.00
2007 $800.00

Educational:

Year Amount
2006 $7750.00
2007 $8700.00

Financial:

Year Amount
2006 $653.00
2007 $4700.00

Here is how it look if I don't enter in the Medical field. I want the rest
of the data shift up.


Intervention Strategy


..

















..


Educational:

Year Amount
2006 $7750.00
2007 $8700.00

Financial:

Year Amount
2006 $653.00
2007 $4700.00

To help yourself diagnose just what is happening, add background colors,
borders, shading, or some such to the text boxes. You can remove these once
the problem is solved.

Yes, all sections are set to can Shrink.

[quoted text clipped - 10 lines]

 

[Duane Hookom]

Would you mind sharing your report's field names? This looks like it might
be fairly normalized if the Year and category values are not field names.

Maybe you should share your report's record source SQL view.

--
Duane Hookom
MS Access MVP

sorry but I am kind of confuse at this point. Ok, this is how my report
look
like when everything is filled out.


Intervention Strategy

Medical:

Year Amount
2006 $440.00
2007 $800.00

Educational:

Year Amount
2006 $7750.00
2007 $8700.00

Financial:

Year Amount
2006 $653.00
2007 $4700.00

Here is how it look if I don't enter in the Medical field. I want the
rest
of the data shift up.


Intervention Strategy


.

















.


Educational:

Year Amount
2006 $7750.00
2007 $8700.00

Financial:

Year Amount
2006 $653.00
2007 $4700.00

To help yourself diagnose just what is happening, add background colors,
borders, shading, or some such to the text boxes. You can remove these
once
the problem is solved.

Yes, all sections are set to can Shrink.

[quoted text clipped - 10 lines]

Thank you.
Kim

 

[qkimchi via AccessMonster.com]

Medical
=IIf(IsNull([Med2007] Or [Med2008] Or [Med2009] Or [Med2010] Or [Med2011] Or
[Med2012] Or [Med2012] Or [Med2013] Or [Med2014] Or [Med2015] Or [Med2016]),
Null,"Medical")

Year
=IIf(IsNull([Med2007]),Null,"2007")

Amount
Med2007Amt

I also have the Total next to Medical which only show when there is a value
entered.

=IIf([txtFinancialTotal]=0,"",[txtmedicaltotal])
=Sum(Nz([Med2007Amt]+[Med2008Amt],0)+Nz([Med2009Amt],0)+Nz([Med2010Amt],0)+Nz
([Med2011Amt],0)+Nz([Med2012Amt],0)+Nz([Med2013Amt],0)+Nz([Med2014Amt],0)+Nz(
[Med2015Amt],0)+Nz([Med2016Amt],0))

Would you mind sharing your report's field names? This looks like it might
be fairly normalized if the Year and category values are not field names.

Maybe you should share your report's record source SQL view.

sorry but I am kind of confuse at this point. Ok, this is how my report
look

[quoted text clipped - 52 lines]

 

[Duane Hookom]

I take back my comments about "fairly normalized". Wow, have you considered
redoing your table structure? Or maybe this is the result of a crosstab
query.

Either way, you might want to redo your expression. Your
=IIf([txtFinancialTotal]=0,"",[txtmedicaltotal]) will never shrink if
txtMedicalTotal is not null.

I would work hard on normalizing prior to spending much time on anything
else.

--
Duane Hookom
MS Access MVP
--

Medical
=IIf(IsNull([Med2007] Or [Med2008] Or [Med2009] Or [Med2010] Or [Med2011]
Or
[Med2012] Or [Med2012] Or [Med2013] Or [Med2014] Or [Med2015] Or
[Med2016]),
Null,"Medical")

Year
=IIf(IsNull([Med2007]),Null,"2007")

Amount
Med2007Amt

I also have the Total next to Medical which only show when there is a
value
entered.

=IIf([txtFinancialTotal]=0,"",[txtmedicaltotal])
=Sum(Nz([Med2007Amt]+[Med2008Amt],0)+Nz([Med2009Amt],0)+Nz([Med2010Amt],0)+Nz
([Med2011Amt],0)+Nz([Med2012Amt],0)+Nz([Med2013Amt],0)+Nz([Med2014Amt],0)+Nz(
[Med2015Amt],0)+Nz([Med2016Amt],0))

Would you mind sharing your report's field names? This looks like it might
be fairly normalized if the Year and category values are not field names.

Maybe you should share your report's record source SQL view.

sorry but I am kind of confuse at this point. Ok, this is how my report
look

[quoted text clipped - 52 lines]

Thank you.
Kim

 

[Guest]

The solution is not in the property settings of the report, you need to
change the properties of the field in the database table. Open the table in
the design view. Look at the "General" tab and set "Allow Zero Length" to
"Yes." Then go back to your report and the field will be skipped if there is
no value.

Hope this helps.
BBMCM