Roy,

Thanks for the quick response but I'm having some trouble with the code.

If TypeName(oCtrl) = "TextBox" & oCtrl = Empty Then
From this snippet of code For the TypeName portion should I replace this with the name of the userform or the name of the textbox? I have currently tried both and have generated run time errors in both instances.