On a form I have some code behind the 'on update' event procedure to change the case format of the entered text. The field is DoctName

if not isnull(DocName) then
DocName = Strconv(DocName,vbProperCase)
end if

I want to put this code behind other fields on the form but of course with the correct field name. Can I create a procedure and then call the procedure from the 'on update' for each relevant field on the form. If so how can I refer to the field name (which will of course change) in the procedure.

Yes you can by creating a procedure for instance


but may I suggest in the interest of simplicity you use the

ucase function

me.docname = UCase(me.docname.value)
just change the field name as appropriat e
if null is passed no error occurs - null is returned thus eliminating a needless check



ALTERNATIVELY SHOULD YOU WISH A GENERIC PIECE OF CODE
code
sub ChangeToU_Case( frmName as string , txtBoxName as string)


forms!frmname!txtBoxName.value = ucase(forms!frmname!txtBoxName.value)
forms!frmname.refresh
end sub
/code
CONTINUE.......
----------------------

on each of the after update EVENTS OF YOUR FIELDS
ChangeToU_Case(me.name & " " & Me.Text0.Name)

Replace the Text0 with the names of the fields on which you wish to implement the code

**********************************************
NB *****
CHECK BEFORE RUNNING AS I AM IN 2007 AND THINGS HAVE CHANGED MIGHTILY

jO