Hi Nadya,


>This column would become read-only. I am wondering for a solution to have it directly updatable...

Yes, but as it so happens this is ok for this situation.


>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....

But thats too sophisticated for me :)

Thanks for the input and nice to hear form you again! Stay well.


>
>>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.
>>>