OK, then use the Replace function in the AfterUpdate event of the control to
replace "-" with "". Something like this:
Private Sub txtSSN_AfterUpdate()
txtSSN= Replace(txtSSN, "-", "")
End Sub
Where the name of the control is txtSSN.
--
--Roger Carlson
MS Access MVP
Access Database Samples:
www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L
"pokdbz" <(E-Mail Removed)> wrote in message
news:A749F3B0-786E-41E2-A3C1-(E-Mail Removed)...
> I really wasn't looking for a input mask. Because not always are they
going
> to be putting in a SSN. It could be just a regular number like 11223.
>
> "Roger Carlson" wrote:
>
> > Create an input mask like this for the textbox:
> > 000-00-0000;;_
> >
> > This will show the dashes in the texbox when the value is entered,
whether
> > or not they type them, but it will not store the dashes with the value.
> >
> > --
> > --Roger Carlson
> > MS Access MVP
> > Access Database Samples: www.rogersaccesslibrary.com
> > Want answers to your Access questions in your Email?
> > Free subscription:
> > http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L
> >
> >
> > "pokdbz" <(E-Mail Removed)> wrote in message
> > news:FB7DF6C0-A121-4EFC-B8D2-(E-Mail Removed)...
> > > I have a text box where a number is suppose to be entered. Sometime
like
> > a
> > > SSN. So if someone puts in 111-22-3333 I would like it to disregard
the -
> > > and just store the 11122333. How can you do this?
> >
> >
> >
Similar Threads
