inputting zip-code leading zero gets dropped off

[MBall2003]

I have a text box on my form for the addresses zip code

the input mask is 00000\-9999;;_
my problem is when the zipcode starts with a zero, ex. 07654 or 09356-9856 the following gets inputted into the table 7654 and 9356-9856 how can i get the leading zero to stay ?? any help would be appreciated thanks


mball

 

[Newposter]

Check your input source, Access sees it as a number format rather than text. Re-format the input source as text first (this may drop the zeros in your original data, you'd have to put them back), then bring into Access.

Newposter
"Good judgment comes from experience. Experience comes from bad judgment."

 

[MBall2003]

thanks works fine now

mball