Recent content by Jamers2004

Thank you I will try that! I really appreciate your help. Wish I could send you some cookies.

This is homework, there is only one possible scenario and I've been working on this issue for literally 8 hours. We literally just learned about Left, Mid, Right, InStr and Len and this is one tiny portion of my assignment, after a 3 minute tutorial on those functions.

I'm assuming because it's what's expected of me. I need to write a code where the user will input their first/MI./last in a textbox. Then, using the left([Name], 1) etc. I need to be able to either look for the spaces and grab the first letters based on that, or some other way. I understand that...

I am looking to extract initials from a single textbox using Left, mid and other similar functions. The user enters their first, middle initial and last name; assuming spaces and a period after the middle initial. I need to ensure the initials extracted are uppercase, even if the text is entered...