Strip input mask in query results?

[Stan Denman]

I have a client table with a social security number field that uses the MS Access Data Input Mask Wizard value for Social Security Number. I am automating an online application form for clients that requires the SSN without the mask (just straight 000000000). When I examine my query that is the source for the online form data, I can click on the properties tab for the SSN field in the query but there is no value corresponding to "Input Mask" so there is nothing to try and clear.

[June7]

You have the SSN stored with hyphens and want to remove them for the online app? Try this in the query:

Replace(SSN,"-","")