Trim Function gets rid of the input mask

  • Thread starter Thread starter Deb
  • Start date Start date
D

Deb

I have an input mask for a zip code, so I can have the 9
digit zip code with a hypen, and it works just fine if I
dont use the trim function, but when putting it on a
label with the trim function, the hyphen goes away and it
puts all 9 numbers together....where can I tell it I want
a hypen on a report for creating a "label" ?
 
Assume you're using Trim to account for zips that don't
have the last four.

One solution is 2 fields, Zip and Plus4, then concantenate
them for display.

Roxie Aho
 
I dont want to split the fields, since I already have 200
records typed in it......

the trim function is for the whole city, state, zip code
line, not specifically for the zip part....the 5 digit
zips show up just fine without a hypen at the end, but
the 9 digit zips dont have the hyphen between
them.....why would the trim take away the hypen..I have
the hypen in both the format and input mask section....

--Deb
 
Hi Deb,

Use the Format() function, something like

Format([Zip], "00000-0000")

This is just one of the reasons why I and many other people almost never
use input masks. I'd always store a zip code or SSN in a text field (not
a number field, numbers are things you do arithmetic with) complete with
hyphens.
 
Back
Top