Putting a - into an imported zip code field

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

I'm importing a table from Excel into Access that has a
zip code column without a dash. The zip codes import into
Access, however, the data ignors the zip code input format
once imported.

What can I do to get the dash to appear in reports?
 
Create an unbound control on your report named txtZip. Then, make the
control source the following:

= Left([ZipCodeField], 5) & "-" & Right([ZipCodeField], 4)

hth,
 
Back
Top