If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report Shrink
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 |
#2
|
|||
|
|||
Report Shrink
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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Sam" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|