Side by Side can grow, can shrink

  • Thread starter Thread starter Cyndi
  • Start date Start date
C

Cyndi

I want two fields side by side on a report - that can grow, can shrink

for different records - they might both have info, only 1 might have info or

both may not have any info, when I put them on my report and put them can grow,

can shrink it makes them both appear on every record

Here's what it should look like

CCCCCCCCCCCCCCCC DDDDDDDDDDDDDDD EEEEEEEEEEEEEE
ffffffffffffff gggggggggggg
CCCCCCCCCCCCCCCC DDDDDDDDDDDDDDD EEEEEEEEEEEEEE
gggggggggggg
CCCCCCCCCCCCCCCC DDDDDDDDDDDDD EEEEEEEEEEEEEE
ffffffffffff
CCCCCCCCCCCCCCCC DDDDDDDDDDDDD EEEEEEEEEEEEEE
CCCCCCCCCCCCCCCC DDDDDDDDDDDDD EEEEEEEEEEEEEE

Thanks
 
Create the fields then stack them as you want them to look
if fully 'grown'. I assume the lower case lettered fields
are the ones you want to grow. Select the two growable
fields then in "Properties" select can grow for both.
Then size them to zero height. They will disappear unless
there is data in them. Good luck!
 
thanks for the try but it didnt work - what it does is throw a line in
there after every record whehter there is info or not
 
Please clarify "throw a line in there". I just checked on an Access 2002
report and two side-by-side controls with Null values in the records shrank
to nothing. Did you make sure the Section in which they reside also has
CanShrink set to Yes? There must, of course, be no other unshrunked controls
side-by-side with them, and that includes unattached label controls.

Larry Linson
Microsoft Access MVP
 
All sections set to yes can grow can shrink

Here is my report

1st Report

1st Line XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
CGCSbox XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
1st Sub same
2nd Sub same

using the idea here i get a line for notes after 1st line whethere
anything there or not no labels on second line only the text box that
should grow or shrink.

Thansk
 
Back
Top