uppercase string causes trouble?

[bill crumpton]

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

 

[Jack Cowley]

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

 

[bill crumpton]

Thanks Jack I'll try that.

BAC