Side by Side can grow, can shrink

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
 
T

TEK

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

Cyndi

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
 
L

Larry Linson

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
 
C

Cyndi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top