Grid Column - Multiple Control Sources...

[GriffMG]

I have a form with a grid on it. The second column has (up until now) had a number of possible controls all of which are bound to a single field in the underlying table.

Currently, if a controlling, different, field is set to .t. the current control is set to a read-only edit box field - otherwise it is set to an edit box that the user can fill in.

Now I want to use the same column to display an option group based on a different field altogether - a numeric field instead of a memo - if another field in the table is set to 'O' (the existing records all being blank).

The display part seems to work, I can SHOW the correct value in the grid, but if I try to alter it I get a 'field type mismatch error'.

Any idea what I'm doing wrong? Can this be done?

Thanks in advance

Martin

Regards

Griff
Keep [Smile]ing

 

[GriffMG]

I worked it out...

You have to remove the control source and the binding from the column - then save the form and exit.

Then reopen the form and change the control source for the individual controls within the grid column.

Bingo!

Regards

Griff
Keep [Smile]ing