Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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


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

Recommended Posts

Posted

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

Posted (edited)

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
  • Like 1
Posted

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.

This topic is 4442 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
×
×
  • Create New...

Important Information

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