Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting zero's to show up in reports

Status
Not open for further replies.

Tonberry

Technical User
May 27, 2003
5
US
I'm having a little problem with access. I'm entering zip codes into a table and then when I click on report view the zip codes (like the ones in New Jersey) have zero's in front of them which don't show up in report view. I'm not very experienced with access and I've been trying to use masks to correct the problem, but no luck. Any help would be appreciated.

Thanks
-Don
 
Oh, I forgot to add that the table was imported from Excel.
 
Try setting the format of the field to 00000, or 00000-0000 if it's Zip+4
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top