Len25 and Bob,
I just read something interesting in "Access 2007 VBA" book by Teresa Henning, Rob Cooper, etc.. (ISBN 978-0-470-04703-3, page 354 under "Current Event" :
"You can use the 'Current' event to apply custom formating to a field."
and then:
The 'Current' event does not fire when...