Shrink Text box

[Ashish Kanoongo]

Hello there,
I m using a microsoft access database report, i have 5 rows followed by sum of variables in 5 rows, i want the sum to be printed just after the last row with data, e.g. if 4th and 6th rows are blank , the sum should be displayed just below the 3rd record. I have used shrink text box properties but nothing seems working fine , can any one throw some light on it,
thanks and regsrds
Andy

 

[Duane Hookom]

The text boxes will not appear to shrink if there is any control to the left
or right of the text box. Also, non-null values will not allow the text box
to shrink.

--
Duane Hookom
MS Access MVP


Hello there,
I m using a microsoft access database report, i have 5 rows followed
by sum of variables in 5 rows, i want the sum to be printed just after the
last row with data, e.g. if 4th and 6th rows are blank , the sum should be
displayed just below the 3rd record. I have used shrink text box properties
but nothing seems working fine , can any one throw some light on it,
thanks and regsrds
Andy

 

[Ashish Kanoongo]

Yes I have two textbox on same row, but I want both of the textboxes to be
shrink at the same time.

 

[Duane Hookom]

They will both shrink if they both are set to Can Shrink: Yes and they are
both Null.

 

[Ashish Kanoongo]

But one of the textbox is currency type, and 0.00 is never treated as Null.

 

[Duane Hookom]

If the text box has a value then it will not shrink. I think part of your
problem is that it seems you are adding/summing across fields rather than
across records. This makes me think your table isn't normalized but I could
be wrong.