Jump to content

sliding


Mandu
 Share

This topic is 5697 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 5697 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.