Putting a - into an imported zip code field

[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?

 

[Cheryl Fischer]

Create an unbound control on your report named txtZip. Then, make the
control source the following:

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

hth,