Can anyone explain why the following code placed on a control would cause the user not be able to navigate through the records in a form?

Me.lastname = StrConv(Me.lastname, vbUpperCase)

For example: The above function is associated to the "On Exit" property of a control which stores the last name of a person. However, when I go back to scroll through the records using the navigation tool at the bottom of the form and if the control [lastname] has got the focus I am unable to scroll to the next record until I change the focus to another control without the Upper Case conversion code.

Any help is appreciated. Thanks.

BAC

Move your code from the On Exit event to the After Update event of the Field.

Thanks Jack I'll try that.

BAC