Hi:
How can I clean up a GRIDCOL6 with this control source:
trim(b1b250.a31)+', '+trim(b1b250.a32)+', '+trim b1b250.a33)
A31=street
A32=City
A33=State
When I don't have an "street" I would like to get rid of the commas and replace a31 with "To Be Determined" in the grid even though city state may be availbable.
THX for any feedback.
Bill
How can I clean up a GRIDCOL6 with this control source:
trim(b1b250.a31)+', '+trim(b1b250.a32)+', '+trim b1b250.a33)
A31=street
A32=City
A33=State
When I don't have an "street" I would like to get rid of the commas and replace a31 with "To Be Determined" in the grid even though city state may be availbable.
THX for any feedback.
Bill