Report Shrink

S

Sam

Hello,

I am running a report where I have a number of name fields one under
another. Is there a way to autmatically shrink the lines if one of the name
fields is left empty? For exmaple:

Person1
Person2
Person3

Person1



Person1
Person2
Person3

As you can see the spacing is the same whether or not a record has all three
name fields filled out or not.

Thank you in advance,
Sam
 
D

Douglas J. Steele

Text boxes on reports have both a CanShrink and a CanGrow property. You may
be best off making the control tall enough for one row of data and setting
its CanGrow property rather than the other way around.
 

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

Similar Threads

Report 1
Outlook Email Help: Select custom voting button options VBA 0
Check if that person is absent 1
Multiple columns from one set of data? 2
checkbox with many choices 1
Pivot Table Sub total and totals 4
Macro Question 0
Splitting 1 column into 2 columns 8

Top