field edit

[scott1891]

In a form how can I have a field setup to require a user to double click the field to either enter new information or to edit current information.

 

[Frink]

Hallo,

Make the control locked (and preferably a different background colour so they know it's locked)
In the doubleclick event procedure make the control unlocked (and change the colour)
they can then edit it.
In the After Update event procedure make the control locked and coloured again.

A tip here would be to design the form as the control would appear editable, then write the After Update procedure.
In the forms OnOpen event, call the controls AfterUpdate event. This way it's easier to make more consistent.


If you had a lot of controls, you could write functions (which are passed the control) to do this, which would be quite splendid.

- Frink