>> 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'))
Well, I'm getting some quick results. Actually, I have used the IIF in my report, it works just fine. On screen, though, I'm in editable mode. Therein lies the problem. I've tried some IIFs in both input mask and
format of text box, but no success so far...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.