calvin on first time the controlsource was the evaluation of the iif and not the iif himself.
>When populating columns in a grid, I have some code that goes like this:
>.column1.controlsource=iif(cust.type='R','rfinan.acct','lfinan.acct')
>This works for 99% of my customers. However 1 customer complained that this column did not show anything. He sent me his data and sure enough it showed nothing. After pulling my hair out for about an hour inspiration struck and I chaged the code to read:
>.column1.controlsource="iif(cust.type='R',rfinan.acct,lfinan.acct)" and it now works everywhere.
>Question: Why did the first version ever work?
Alexandre Palma
Senior Application Architect