A Ayo Oct 3, 2009 #1 How do I convert ctrl.Caption to all CAP? summaryTitle = (ctrl.Caption) & " AAV SUMMARY"