Shrink Text box

  • Thread starter Thread starter Ashish Kanoongo
  • Start date Start date
A

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
 
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
 
Yes I have two textbox on same row, but I want both of the textboxes to be
shrink at the same time.
 
They will both shrink if they both are set to Can Shrink: Yes and they are
both Null.
 
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.
 
Back
Top