UCase Macro

[Charlie2]

I am trying to make a macro that i can assign to the after update property of a text box on a form, I have tried this in the macro:

Set Value


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

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

The trouble is this wont work, what am i doing wrong?

Charlie

 

[Charlie2]

The Problem

The problem is I get an error message stating that I cannot save the record at this time when I enter a code, it seems to convert to UCase but there is a problem.