sliding

February 18, 200718 yr

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

February 18, 200718 yr

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. :wink2:

LaRetta

February 22, 200718 yr

Author

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, 200718 yr by Guest