> If you only want to see the number without editing it, try to write at the > source property: > IIF(EMPTY(P#),SPACE(14),"("+LEFT(P#,3)+") "+SUBSTR(P#,4,3)+"-"+RIGHT(P#,4)) > Change "P#" with the field name. > Write the same in the value property. This should work. > > Isaac Handler > ihan@ny.frontiercomm.net > > foxpro@transformation.com wrote: > > > > Does anyone have experience using this format for a text box? You are supposed to be able to have multiple input masks delimited by commas, > according to docume > > > > I'm trying to show input mask (999) 999-9999 for a (char) phone number, but nothing if the field is blank. The phone format 'R' works fine when a > number exists > > > > Thanks > How about IIF(EMPTY(P#),SPACE(14),TRANSFORM(P#,'R(999) 999-9999'))