Trimming a Field

[puthenveetil]

HI all,

Is there any way to trim a field if there is no value in that field. Now I am using this code

=Trim([District] & " Dist.")

The "Dist." is still displaying if there is no value at all.

Thanks in advance.

Thanks

 

[maxmangion]

the purpose of the trim function, is to remove leading and trailing spaces ... that's why you're still getting the "Dist" part, because they are valid characters for the trim function.