Scroll Mouse Highlighting Text

D

Dan Sweetwood

I know that I can turn off the MouseWheel (I would prefer not to) and I have
the memo field set to not be a tab stop. However, when the employee uses the
mouse wheel and scrolls back the original record then that memo field is
highlighted and could accidently be deleted. The text is many days of
therapist notes for patients and can not be replaced easily. your help will
be greatly appreciated. (Yes I did first search for the answer)
 
N

Nikos Yannacopoulos

Dan,

You could set the Allow Edits property of your form to No by default, so
no accidental deletion or other change can happen, add an Edit command
button for existing records to only allow deliberate changes, automatic
"locking" when moving out of the edited record, and automatic
"unlocking" going to a new record. To do all this:

* change the form's Allow Edits property (tab Data) to No
* add a command button (Edit), with this line of code in its Click event:
Me.AllowEdits = True
* put this line of code in the form's On Current event:
Me.AllowEdits = Me.NewRecord

HTH,
Nikos
 
Top