>I have a table with 2 checkboxes in called Yes or No. I am completely constrained to somebody elses tables and I cannot change it. Therefore I have created a a form with a grid. On one of the columns I would like to display whether it say Yes, No or 'No Decision'. Therefore I cannot bind anything to my grid column.
>
>How can I display this in my column on my grid i.e. calculate which checkboxes have been checked?
>
>Many Thanks

Neil

For one, a table doesn't have checkboxes, it has logical fields or yes/no fields, for example. Is that what you mean?
Your grid can have a checkbox in a column too, instead of the default textbox.

You can do an SQL on the table like:

Select Field1, field2, IIF( field3=.T., "Yes", "No") as YesNoField, Field4 ....
into cursor ...

and have the cursor as the recordsource of the grid (bound columns and all).

or

Select Field1, field2, IIF( field3="Affirmative", .T., .F.) as LogField, Field4 ....
into cursor ...

Does this help?

Terry