Obtain field value without its input mask

[rss0213]

Hi. My users created a field in a table with an input mask. How do I obtain this value without its input mask? The field is a fax number, and they have it masked as "(###) ###-####". So when I code "varFaxNum=Customers.FaxNumber", I get "(555) 555-5555". But I just want the numbers - not the spaces and special characters. Do I have to write a routine to do this (to check each character for "IsNumeric"), or is there like an "unmask" function or something?

Thanks!
Scott

 

[Blorf]

If code is returning the formatted number, then not only did the user put a mask on input, but also told it to store the data as masked.

You will have to parse it with mid and right function.

ChaZ



There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://www.thelegacyreturns.com/

 

[rss0213]

Thanks for the feedback. That's what I did.

Thanks!
Scott

 

[missinglinq]

The really scary thing here is that your end users have access to modify tables and presumably anything else they want to! Your glitch here is very small compared to what could happen if this practice continues!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!