>>>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...
>>
>>Perhaps you just can't put any IIF in the input mask or format, but can put it in Valid.
>>
>>Alex.
>
>That might work too, similar to the Interactivechange that Doug came up with. Right now I'm still having trouble getting the grid column to display correctly. Some phone numbers are blank, some not, and for some reason the IIF is not working in either control source or value, it is ignored. I'll have to fiddle with it some more. If I get that to work, I think the edit ideas you guys have come up with will probably work.
>The IIF that is being ignored is:
>iif(!empty(phone),'('+substr(phone,1,3)+') '+substr(phone,4,3)+'-'+substr(phone,7,4),' ')
>It works fine in the command window.
>
>-Thanks
>Bruce

maybe like this
this.setall('Format',"iif(!empty(phone),'(999) 999-9999',' ')",'Column')
in the grid init.
i think this will try to format all columns and haven't used this except to change colors based on data and current record number, but it might work...