Hi:

This should be easy but I have yet to make it work.
I want to change the value of a textbox inside a grid
depending on a logical field in a table.

Eg:
crea table users (user C(10), level L)

The grid has two columns:
grid.column1.ControlSource = users.user
with grid.column2
.ControlSource = users.level
.Bound = .F. && I don't want a ControlSource on the textbox
.ReadOnly = .T.
.Sparse = .F.
endwith

grid.column2.text1.value = iif(users.level, 'Master User', 'Normal User')
FAILS -> it only uses the value of users.level on the first record

Any ideas aside from adding a new field to the table?

TIA