How do I merge text fields and omit empty ones

[Robbydobbs]

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?

[BobWeaver]

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&"

[Robbydobbs]

Thanks Bob that helps a lot.