Hi Jos,
This column would become read-only. I am wondering for a solution to have it directly updatable...
BTW, in such situations I usually have a lookup table, set relation to it and use it in that column instead. It also allows to easily change DynamicBack/Fore colors....
>Hi Hilmar. I orginally tried the IIF() in the control source but that didnt work. Obviously I must have done it wrong becuase I tried it now again and its working perfectly. Must be a Friday :)
>
>Thanks and have a good one!
>
>
>>How about:
>>
>>
>>Column.ControlSource = ThisForm.MySpecialFormat(IntegerField)
>>
>>* Method Form.MySpecialFormat():
>>local lcReturnValue
>>do case
>>case IntegerField = 1
>> lcReturnValue = "Msg 1"
>>...
>>return padr(lcReturnValue, 10)
>>
>>
>>Another option is nested iif's, but this is hard to read.
>>
If it's not broken, fix it until it is.
My Blog