Does anyone have any code that reads a name field that contains the name in the following format (John T Smith), picks up the Firstname, last name, and dumps them into different fields.
InStr(), Len(), and Left()/Right()/Mid() are going to be your best friends on this endeavour. There are examples of how to do this in the archives, but it's a useful skill to learn in general.
i have a code which splits any given text up into words, if you're still interested....send an email to this address and i'll reply with the attachment.