sliding

[Mandu]

Once again I'm flummoxed by a simple sliding problem. I just want a List view with a Name on the left, and up to three phone numbers, arranged vertically, to the right.

Joe Smith___111-2222

____________222-2222

____________333-3333

(Underscores are shown here to maintain horiz. spacing in this posting. In the actual application this is just white space)

I want the phone numbers to slide upward, and I want the row height (the body) to be reduced, when some of the numbers are missing. Currently Joe Smith is a text box with <> merged, and the telephone numbers are a single text box with

<>

<>

<>

merged.

Both text boxes are marked Sliding / based on directly above only / also reduce size of enclosing part.

Here's what I've seen in preview mode when different combinations of phone numbers are blank.

('=' designates row breaks)

================

Joe Smith___111-1111 correct

____________222-2222

____________333-3333

================

Joe Smith___111-1111 also correct; ph2 was blank

____________333-3333

================

Joe Smith___111-1111 wrong, ph3 was blank

____________222-2222

================

Joe Smith___111-1111 wrong, ph2 and ph3 were blank

================

Has anyone got a clue what's going on?

Thanks,

Chap

[LaRetta]

Merge fields won't slide on their own ie won't omit empty fields within the merge box. Instead, you might try a calculation (text) with:

Substitute ( TrimAll ( Ph1 & " " & Ph2 & " " & Ph3 ; 1 ; 1 ) ; " " ; ¶ )

Then place this calculation on your report. Format it to allow 3 lines and set it to slide up.

LaRetta

[Mandu]

Thanks! Works well.

Since there is the possibility of spaces appearing in telephone numbers (e.g. number followed by "ext. 39") I didn't use the Substitute(TrimAll(...)) technique. Maybe there's a "list collapsing" function somewhere which would remove empty items from a list and provide a more general solution? Anyway - it works.

Edited February 22, 2007 by Guest

[Raybaudi]

Hi

if there are some spaces inside those fields, this calc may be better:

Substitute (

TrimAll (

Substitute ( Ph1 & ¶ & Ph2 & ¶ & Ph3 ;

[ " " ; "§" ] ; [ ¶ ; " " ] )

1 ; 1 ) ;

[ " " ; ¶ ] ; [ "§" ; " " ]

)

[LaRetta]

See the paternal father's calc here .

LaRetta

[Raybaudi]

Hi LaRetta

yes...comment have given so much ! :