July 8, 200322 yr I have several fields stacked on top of each other like this: c_transportscr c_smartspotscr c_smogfeescr the field "c_transportscr" = Case(s_totaltransportfee <> 0,("TRANSPORTATION FEE") & " = " & " " & s_totaltransportfee &".00"," ") answer: Transportation Fee = 25.00 The Field "c_smartspotscr" = Case(c_totalss <> 0, ("SMART SPOT FEE" & " = " & " " & c_totalss &".00"), " ") answer: Smart Spot Fee = 35.00 The Field "c_smogfeescr" = Case(c_totalsmog <> 0,("SMOG FEE" & " = " & " " & c_totalsmog &".00"), ") Answer: Smog Fee = 25.00 so then the fields would look like this: Transportation Fee = 25.00 Smart Spot Fee = 35.00 Smog Fee = 25.00 But if there was no Smart Spot Fee then it would look like this: Transportation Fee = 25.00 Smog Fee = 25.00 and I want it to automatically move a field up if the previous field is empty, like this: Transportation Fee = 25.00 Smog Fee = 25.00 How do I tell it to move up the next field if the previous field is empty?
July 9, 200322 yr For printing or preview mode, just select the sliding/printing options for the fields. If you want them to slide in browse mode, you need to create a calculated field for display: DisplayField = Substitute(Substitute(Field1&"
Create an account or sign in to comment