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 Lis
----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Friday, January 07, 2005 11:35 AM
Subject: [RBG7-L] - Re: Format Mask -- does not display properly untilfocus is in that field
At 08:57 PM 1/6/2005, Bernie Lis wrote:
Problem is not as originally stated. It is deceiving because -- phone number is stored as 1234567890 When displayed, the format mask does not take effect until focus is in that field, so it appears as 1234567890 instead of 123-456-7890. So unless the user enters that field he will not see it displayed as expected.
Bernie,
Keep in mind that Format Mask used in DB Edits is for "DATA INPUT" and not to display. So, it only takes effect when focus is on that field to input data.
Hope that explains to avoid any confusion.
Very Best R:egards,
Razzak.
