Disable cells in a grid individually

[Dan Neely]

Can I en/disable cells in a gridview based on the content of other values
instead of only an entire column at a time?

 

[Stefan Hoffmann]

hi Dan,

Can I en/disable cells in a gridview based on the content of other values
instead of only an entire column at a time?

I assume you mean the gridview of a form:

As each cell represents a control, you can use this control to set
Active and/or Locked to False.


mfG
--> stefan <--

 

[Dan Neely]

I assume you mean the gridview of a form:

As each cell represents a control, you can use this control to set
Active and/or Locked to False.

How do I get a specific cell cell? Me.ControlName.Enabled toggles the
entire column.

 

[Stefan Hoffmann]

hi Dan,

How do I get a specific cell cell? Me.ControlName.Enabled toggles the
entire column.

You need to set Locked = False in to Form_Current event.


mfG
--> stefan <--

 

[Dan Neely]

You need to set Locked = False in to Form_Current event.

Locked defaults to false for bound controls. ControlName.Locked also
affects the entire column, not individual cells within it.

 

[Stefan Hoffmann]

hi Dan,

Locked defaults to false for bound controls. ControlName.Locked also
affects the entire column, not individual cells within it.

But the Form_Current event can unlock it, if you click in a row where
you should edit it.

mfG
--> stefan <--

 

[Dan Neely]

hi Dan,

But the Form_Current event can unlock it, if you click in a row where
you should edit it.

I'm not clear what you're suggesting I do here.

 

[Dan Neely]

I'm not clear what you're suggesting I do here.

Nevermind, I do now.