How to Use Format and InputMask to Format Data

MORE INFORMATION

   @ 3,3 GET cVar PICTURE "@R (999) 999 - 9999"
				

Step-by-Step Example

1. Create a table using the following code:

      CREATE TABLE phonelist (Company C(20), Phone C(10))
      INSERT INTO phonelist VALUES ("Buggy Hut","1111111111")
      INSERT INTO phonelist VALUES ("More Huts","2222222222")
      USE
   							

2. Create a form and put Phonelist.dbf in the Data Environment. Drag the phone field onto the form. Also, drag the phonelist table to the form to create a grid object.
3. Using the Properties Window, set the following properties of the phonelist.phone field to these values:

      Format - R
      InputMask - (999) 999 - 9999
   							

4. From the object list in the Properties Window, select the grid object and set the ColumnCount property to 2.
5. Select the text box in Column2 and set the Format and InputMask properties to the same values as used in Step 3.
6. From the Property Window, select Column2 from the object list. Change the Sparse Property to false (.F.).
7. Save and run the form. Notice that the data is formatted with parentheses and a dash.
8. Change the phone field in the text box for the first record ("Buggy Hut") to 1112223333. Notice that the data you enter is still formatted the same way in the grid and the text box.