Extracting First Name from Full Name Field in Access 2000 1

[jimdevon]

I have read some answers for the split function, but do not understand. I need to take the first and last names from a full name field to create two separate fields. I have two empty fields in the table which I wish to fill. Thanks in advance. Jimdevon

 

[thornmastr]

What does your name field consist of. For example, is it first name, comma, lastname, comma, title? Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[borg2002]

I suppose your full name field is built like "Firstname Initials Lastname". And the field is named txtName. The first name comes into the field txtFname, lastname in txtLname.

Dim Lname As String
Dim Fname As String
Dim length As Integer
Dim occ1 As Integer
Dim occ2 As Integer
Dim str As String

length = Len(txtName)
occ1 = InStr(txtName, " &quot
Fname = Left(txtName, occ1)
txtFname = Fname
str = Right(txtName, length - occ1)
occ2 = InStr(str, " &quot
length = Len(str)
Lname = Right(str, length - occ2)
txtLname = Lname


Kind regards
Borg