>>>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
Isn't a this.refresh() missing somewhere?
Alex.
Alexandre Nobre
Alpha Bytes Computer Corp.
Did you know that there are innocent people dying in East Timor?
It helps if you do...
I suppose you don't need glasses if you're able to read this line