I'm not sure, Oliver. Interestingly, when I was fooling around with this last night, I tried putting the controlsource assignment

column3.controlsource ="roomtype(room.room_type)"

in the grid's init and got the message (not surprisingly) that the controlsource has to be a variable. So, then I tried a simple IIF condition in your original code

IIF( room.room_type = 1, 'whatever', 'somethingelse')

. That worked.

Perhaps one of the folks who know more of the inner workings will contribute their understanding...


>Why the ControlSource cannot directly to assign the function roomtype()?