Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Is there anything in this function that will keep it from shrinking?

Featured Replies

If ( IsEmpty ( Act1 ); ""; Act1) & " " & If ( IsEmpty ( A1_Start); ""; "-- Start: "& A1_Start) & " " & If ( IsEmpty ( A1_Stop ); ""; "-- Stop: "& A1_Stop) & ¶ &

If ( IsEmpty ( Act2 ); ""; Act2) & " " & If ( IsEmpty ( A2_Start); ""; "-- Start: "& A2_Start) & " " & If ( IsEmpty ( A2_Stop ); ""; "-- Stop: "& A2_Stop) & ¶ &

If ( IsEmpty ( Act3 );""; Act3) & " " & If ( IsEmpty ( A3_Start); ""; "-- Start: "& A3_Start) & " " & If ( IsEmpty ( A3_Stop ); ""; "-- Stop: "& A3_Stop) & ¶ &

If ( IsEmpty ( Act4 );"";Act4) & " " & If ( IsEmpty ( A4_Start); ""; "-- Start: "& A4_Start) & " " & If ( IsEmpty ( A4_Stop ); ""; "-- Stop: "& A4_Stop) & ¶ &

If ( IsEmpty (Act5 );"";Act5) & " " & If ( IsEmpty ( A5_Start); ""; "-- Start: "& A5_Start) & " " & If ( IsEmpty ( A5_Stop ); ""; "-- Stop: "& A5_Stop) & ¶ &

If ( IsEmpty (Act6 );"";Act6) & " " & If ( IsEmpty ( A6_Start); ""; "-- Start: "& A6_Start) & " " & If ( IsEmpty ( A6_Stop ); ""; "-- Stop: "& A6_Stop) & ¶ &

If ( IsEmpty (Act7 );"";Act7) & " " & If ( IsEmpty ( A7_Start); ""; "-- Start: "& A7_Start) & " " & If ( IsEmpty ( A7_Stop ); ""; "-- Stop: "& A7_Stop)&¶ &

If ( IsEmpty (Act8 );"";Act8) & " " & If ( IsEmpty ( A8_Start); ""; "-- Start: "& A8_Start) & " " & If ( IsEmpty ( A8_Stop ); ""; "-- Stop: "& A8_Stop)&¶ &

If ( IsEmpty (Act9 );"";Act9) & " " & If ( IsEmpty ( A9_Start); ""; "-- Start: "& A9_Start) & " " & If ( IsEmpty ( A9_Stop ); ""; "-- Stop: "& A9_Stop)&¶ &

If ( IsEmpty (Act10 );"";Act10) & " " & If ( IsEmpty ( A10_Start); ""; "-- Start: "& A10_Start) & " " & If ( IsEmpty ( A10_Stop ); ""; "-- Stop: "& A10_Stop)

No matter what I try, and I've been trying for hours, this merge field will not shrink. On the printout, it is still long enough to accommodate all 10 acts when you only have 4 filled in.

TIA...

1. Try using the List function instead of hard-coding a return so: &¶&. Or at least place the return within the If() statement.

2. You didn't say what this is about, but it seems fairly obvious that those 10 "rows" should be individual records in a related table.

---

BTW, this =

If ( IsEmpty ( Field ) ; "" ; "text" )




can be written more conveniently (IMHO) as =




If ( not IsEmpty ( Field ) ; "text" )

Edited by comment

  • Author

Thanks Comment. Placing the return within the ()If Statement worked perfectly.

If ( IsEmpty ( Act1 ); ""; Act1) & " " & If ( IsEmpty ( A1_Start); ""; "-- Start: "& A1_Start) & " " & If ( IsEmpty ( A1_Stop ); ""; "-- Stop: "& A1_Stop & ¶ ) &

If ( IsEmpty ( Act2 ); ""; Act2) & " " & If ( IsEmpty ( A2_Start); ""; "-- Start: "& A2_Start) & " " & If ( IsEmpty ( A2_Stop ); ""; "-- Stop: "& A2_Stop & ¶ ) &

If ( IsEmpty ( Act3 );""; Act3) & " " & If ( IsEmpty ( A3_Start); ""; "-- Start: "& A3_Start) & " " & If ( IsEmpty ( A3_Stop ); ""; "-- Stop: "& A3_Stop & ¶) &

If ( IsEmpty ( Act4 );"";Act4) & " " & If ( IsEmpty ( A4_Start); ""; "-- Start: "& A4_Start) & " " & If ( IsEmpty ( A4_Stop ); ""; "-- Stop: "& A4_Stop & ¶) &

If ( IsEmpty (Act5 );"";Act5) & " " & If ( IsEmpty ( A5_Start); ""; "-- Start: "& A5_Start) & " " & If ( IsEmpty ( A5_Stop ); ""; "-- Stop: "& A5_Stop & ¶) &

If ( IsEmpty (Act6 );"";Act6) & " " & If ( IsEmpty ( A6_Start); ""; "-- Start: "& A6_Start) & " " & If ( IsEmpty ( A6_Stop ); ""; "-- Stop: "& A6_Stop & ¶) &

If ( IsEmpty (Act7 );"";Act7) & " " & If ( IsEmpty ( A7_Start); ""; "-- Start: "& A7_Start) & " " & If ( IsEmpty ( A7_Stop ); ""; "-- Stop: "& A7_Stop & ¶) &

If ( IsEmpty (Act8 );"";Act8) & " " & If ( IsEmpty ( A8_Start); ""; "-- Start: "& A8_Start) & " " & If ( IsEmpty ( A8_Stop ); ""; "-- Stop: "& A8_Stop & ¶) &

If ( IsEmpty (Act9 );"";Act9) & " " & If ( IsEmpty ( A9_Start); ""; "-- Start: "& A9_Start) & " " & If ( IsEmpty ( A9_Stop ); ""; "-- Stop: "& A9_Stop & ¶) &

If ( IsEmpty (Act10 );"";Act10) & " " & If ( IsEmpty ( A10_Start); ""; "-- Start: "& A10_Start) & " " & If ( IsEmpty ( A10_Stop ); ""; "-- Stop: "& A10_Stop)

This is what it was intended to look like. The Curfew line would not slide up.

post-102845-0-39761300-1348520470_thumb.

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.