>>>I am trying to print a layout of 8 lines where
>the
>>>first three lines are only there some of the
>time
>>>and line 2 of the address (line 7 of the label)
>>>likewise. I tell the layout to remove the lines
>>>when blank.
>>>
>>>The problem is that whenever some of the lines
>are
>>>blank and removed, the labels "slip" so that
>they
>>>are not aligned properly.
>
>I found a workaround for this - not elegant or
>pretty, but it works. Unfortunately, it is
>dependent on the particular data.
>
>In my case, the lines most likely to be blank are
>the 3rd, the first two and line 2 of the address.
>The address line is handled by an IIF(), so is not
>a problem. The problem lies in trying to build
>expressions to handle lines 3, and 1,2 that aren't
>too long for the expression builder. However,
>because line 3 is the one that makes the label
>look hacked, I have got the labels to move lines 1
>& 2 down one line if 3 would be blank. Then, of
>course, we tell the users we are "centering the
>label" <g>.
>
Charles
Sounds like SOSDD... Yes I have struggled with this also.
One other thing as far as data goes, look at .NULL.'s They can sometimes occuppy the space needed. IE: in averaging values they will take up the slack for empty or missing values. Don't know but worthing spending 10 minutes reading up on.
Tom