Problem with UCase macro.

[Charlie]

I have been trying to assign a macro to a text box on a form, I have been trying to assign it to the After Update property.
The macro I have been trying to use looks like this:
Set Value

Item:[Forms]![frmTenants]![Credit_Ref#]

Expression: UCase([Forms]![frmTenants]![Credit_Ref#])

This works up to a point it does convert the code I enter to uppercase but I get an error message stating MSAccess will not allow me to save the record at this time.

What am I doing wrong?


Charlie

 

[Dugantrain]

I can't exactly say what's wrong with your code, but this simple procedure should accomplish what you want:

Private Sub YourControl_AfterUpdate()
Me.YourControl=UCase(Me.YourControl)
End Sub

 

[Charlie]

I know what was wrong

I had the macro assigned to the after update property of the whole form instead of the text box, thanks for the code Ill try and remember that one.


Charlie