>it's embarrasing to see how simple that answer is - i was looking for the answer by a much more complicated means. i guess the simplest answers are always the hardest to see.
>Thank you for your help.
Be careful with this - if you tab through this you COULD end up with your value being divided by 100 repeatedly. You may prefer to NOT have the field value as the controlsource. In the WHEN clause, set This.value = MyField*100 and in the LostFocus say REPLACE MyField with This.value/100.
HTH
Barbara