Your Dummy VBMan has found that, if using code for Propercase in the last field on a form (e.g. Flds 1-3, Fld3, then next record), code does not work. Should the Propercase Code in that case operate from another option?

This is not Jack ....... but how are you triggering the function (what event)?

Being I don't know the details of what you are attempting to do .... could you explain?

RDH

Rich - I think I suggested using the code in the After Update event of the field, but it has been a while so I really don't remember. Mr. Hicks is correct in asking you what event you are using to trigger the code so please remind us and we should be able to give you an answer....

Yes, definitely AfterUpdate, but only on this last of 9 fields does it produce the Error "Argument Not Optional". It must relate, i guess, to the fact that Tabbing on this field also closes the record and moves to the next blank record.
Tks in advance.