At 05:32 PM 1/7/2005, Bernie Lis wrote:
Hi Razzak, Yes it does, thank you. The data was imported from Act and it is in all digits format. So I guess the workaround is to massage the phone no. to insert the parens and dashes. And I guess a good rule is never store the phone no. in digits only if you want to be able to display it formatted.
Bernie,
In that case, follow the options demonstrated in FormatMask sample.
http://www.razzak.com/SampleApplications/FormatMask.zip
If you wish to display as well as store the phone number with parens and digits, you'll need to redefine the column data type as TEXT 14, as demonstrated in FormatMask table. Then, use "(000) 000-0000;1;_" format mask for DB Edit control assigned to phone number column, as demonstrated in FormatMask form.
RUN FormatMask.RMD to demonstrate the use of Format Mask!
Associated Table: FormatMask Associated Form: FormatMask
Enjoy and make sure to have fun!
Very Best R:egards,
Razzak.
