September 24, 201213 yr 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...
September 24, 201213 yr 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 September 24, 201213 yr by comment
September 24, 201213 yr 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.
Create an account or sign in to comment