>>>>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.
No, I have a refresh for the grid, anyway. It works fine with the input mask, at least.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.