I have used the interactivechange event to look for the equal sign and the following character to auto stuff a predefined text string.

The control source is a memo field.

It works wonderfully, with one unfortunate side effect.

When the user hits the enter key the cursor drops as it should and then jumps back up to the location it came from. The chr(13) is in the edit box, but the cursor seems to have a mind of its own.

I did a great deal of testing and found that I could recreate the issue by putting one line of code in the interactivechange event.

myvar = this.value

Weird. Does anyone have an explanation for this? A work around?