Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Input mask question

Status
Not open for further replies.

kmclane

Technical User
Apr 14, 2004
321
US
I am building a report, and I find that I have some phone number fields where an extension has been added to the end of the number. The table was not set up originally with a separate ext field. I tought I could just use an input mask such as : \(999") "000\-0000" Ext."00000;;, and while it pareses the phone number correctly, it does not display the ext where it exists. Anyone know if this should work, or do I need to parse it out first? Thanks, Ken.

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top