Trim and input mask

  • Thread starter Thread starter Maria
  • Start date Start date
M

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
Click to expand...
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!!!!
 
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
Click to expand...
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!!!!
.
Click to expand...
 
Back
Top