Using the picture function for set format

The Picture Function can be used within a formula to print a string "2065555555" in a telephone number format "(206) 555-5555", or to print other strings in fixed formats. If you are using a database field as the string, it will only work if the field is of a fixed and known length.

Note: You cannot use an asterisk as a wildcard in the picture argument. If you put an asterisk in the argument, it will show up as an asterisk in the resulting string.

Here is an example of what the picture function can be used for:

Picture({customer.FAX},"(xxx) xxx-xxxx" ) 

//Prints the values in the Fax field in the following format:

(805) 555-5555, (313) 555-2555, and so on.