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
- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg