Wow. 1) I am in awe, and 2) Thank You so very much. This is amazing.

In the interest of learning, I hope that you'll be game to answer a few newbie questions...

What does this mean and/or why does this work? newVal = Target.Value: .Undo: oldVal = Target.Value
I've never seen the use of colons after anything other than an "=" to declare a variable.

Also, why is it ok to use "case" in Excel but not in Access?

Thank you again!