Trim and input mask

[Maria]

I would like to use the input mask for my postal code as

L9L\ 9L9. However, when I am creating a label, I would

like my address to show as City Provice Postal Code.
With the trim =Trim([City] & " " & [StateOrProvince]
& " " & [PostalCode]) when previewed, the postal code
does not show following the above input mask.

HELP!!!!

 

[Ron Dyson]

Maria,
I don't think you want to use an input mask to output to
a label. Try this:
Trim([City] & " " & [StateOrProvince] & " " &
Format([PostalCode],"@@@ @@@") with PostalCode unaltered.
Ron

-----Original Message-----
I would like to use the input mask for my postal code as

L9L\ 9L9. However, when I am creating a label, I would

like my address to show as City Provice Postal Code.
With the trim =Trim([City] & " " & [StateOrProvince]
& " " & [PostalCode]) when previewed, the postal code
does not show following the above input mask.

HELP!!!!
.