[AccessD] Zip code format

Yes! That did it. I don't use the left/right string enough to have thought about that.

Thanks a bunch! My mailing labels are now printed so I can get this stuff in the mail in the morning.

--
Kathryn Rhinehart Bassett (Pasadena CA)
"Genealogy is my bag" "GH is my soap"
kathryn at bassett.net
http://bassett.net   

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Bob Gajewski
> Sent: 11 Jul 2005 9:56 pm
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] Zip code format
> 
> Kathryn
> 
> How about this?
> 
> =[City] & " " & [St] & " " & 
> IIf([Zip]<99999,Left$([Zip],5),Left$([Zip],5) & "-" & Right$([Zip],4))
> 
> Regards,
> Bob Gajewski