Hi All,

I am trying to put Calculated Expresion in Grid Column Control Source but it
is too long.
i.e.
iif(job_status_2='0','Dispatched',iif(job_status_2='1','Accepted',iif(job_st
atus_2='2','Rejected',iif(job_status_2='3','Attended',iif(job_status_2='4','
Commenced',iif(job_status_2='5','Work
Suspended',iif(job_status_2='6','Recommenced',iif(job_status_2='7','Complete
d',iif(job_status_2='8','Created',iif(job_status_2='9','Waiting for
Dispatch',''))))))))))

I want to display to user Description instead of value 0,1,2,3 etc...

Is there any other way to do what i want to achive?

Regards

Dejan

Use a call to a UDF in a procedure file, OR, put the code in a custom Form method, and then call that e.f. ThisForm.MyMethod, or if you must use the expression in-situ try replacing all the iif()'s with a SubStr() e.g.

SubStr( "Dispatched Accepted   Rejected   
Attended   Commenced  Suspended  Recomm
encedComplete   Created    Waiting"
, (jobStatus * 11 ) - 10, 11 )

Note that each phrase is 11 characters long.