H
henrique
Guest
Why names should always be entered in at least two fields, which represent the first and last names?
Fornatian
Dim Person
- Local time
- Today, 18:40
- Joined
- Sep 1, 2000
- Messages
- 1,394
You only need to separate names into separate fields because in future you may want to use the separated information for different tasks suchas:
For The Attention Of: <<FNAME>><<MIDDLE>><<LNAME>>
Dear <<FIRSTNAMEFIELD>>
It is easier to put things back together than it is to pull them apart in a useful way.
For The Attention Of: <<FNAME>><<MIDDLE>><<LNAME>>
Dear <<FIRSTNAMEFIELD>>
It is easier to put things back together than it is to pull them apart in a useful way.
Adding to Fornatian's post...
Therefore you can SORT ON or SEARCH BY FirstName or LastName. If they were in the same field this wouldn't be easy. The problem you may be thinking of is joining them which is a rather simple...
Textbox.ControlSource =FirstName& " "& LastName
Therefore you can SORT ON or SEARCH BY FirstName or LastName. If they were in the same field this wouldn't be easy. The problem you may be thinking of is joining them which is a rather simple...
Textbox.ControlSource =FirstName& " "& LastName
