Hi,
I have a full name in text box in a form (Access 2003) like this:
Betty A. Wells
I want to show names (First, Last and Middle) in seperate text boxes.
I was able to get First and last by doing:
=Left([PartName],InStr([PartName]," ")-1)
=Right([PartName],InStr([PartName]," ")-1)
i am not sure how to do Middle name.
Thanks in advance.
I have a full name in text box in a form (Access 2003) like this:
Betty A. Wells
I want to show names (First, Last and Middle) in seperate text boxes.
I was able to get First and last by doing:
=Left([PartName],InStr([PartName]," ")-1)
=Right([PartName],InStr([PartName]," ")-1)
i am not sure how to do Middle name.
Thanks in advance.