Eliminate the blank spaces

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200511/1

Is your section set to allowing shrinking?

--
Duane Hookom
MS Access MVP
--

"qkimchi via AccessMonster.com" u15272@uwe wrote in message
news:5735745e8a390@uwe...
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200511/1

Yes, all sections are set to can Shrink.

qkimchi wrote:
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

--
Message posted via http://www.accessmonster.com

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

"qkimchi via AccessMonster.com" u15272@uwe wrote in message
news:5735b4a7bab30@uwe...
Yes, all sections are set to can Shrink.

qkimchi wrote:
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

--
Message posted via http://www.accessmonster.com

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.

"qkimchi via AccessMonster.com" u15272@uwe wrote in message
news:5735b4a7bab30@uwe...
Yes, all sections are set to can Shrink.

qkimchi wrote:
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

--
Message posted via http://www.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







BruceM wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200511/1

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


"qkimchi via AccessMonster.com" u15272@uwe wrote in message
news:57371b1b48340@uwe...
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







BruceM wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200511/1

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



Duane Hookom wrote:
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

--
Message posted via http://www.accessmonster.com

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

"qkimchi via AccessMonster.com" u15272@uwe wrote in message
news:573754cc23640@uwe...
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))



Duane Hookom wrote:
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

--
Message posted via http://www.accessmonster.com

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

"qkimchi via AccessMonster.com" wrote:

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200511/1