>Is it possible to dynamically change the caption of a checkbox in a grid column to display "Yes" or "No" according to the datasource for the checkbox? When first asked by the client I gave the standard "Sure" but now I'm *not* so sure.
>
>Several times I've had it working except for an occasional "echo" into the adjacent row as long as focus remains in that column. Nothing I've tried displays the correct values after focus shifts to another column.
Lynda,
Wouldn't that be easy with a view ? With view instead of struggling with a checkbox or ligical value for that matter you'd be doing plain text control. ie:
create sql view v_products as select *, ;
iif(Products.discontinu,"Yes","No ") AS disctext ;
FROM products
* Updatable props etc - written by designer
In your grid then you'd use 'disctext' instead of logical discontinu. It could have these then :
Format = 'M'
InputMask = 'Yes,No'
replace discontinu with (this.Value = 'Yes') in ("v_products")
this.Value = iif(this.Value = 'Yes','No','Yes')
Cetin