Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
05-05-2005, 11:16 PM #1
- Join Date
- Mar 2005
- Thanked 0 Times in 0 Posts
MS Access - how to combine several fields in one field
I have the following three fields.
1. Title - Mr,Mrs, Ms.
2. Last name
3. First Name.
I would like to create a form and combine the 3 fields in one field. When somebody types m, Mr will appear first and then when I choose Mr, I will type the first letter of the last name after a space, once I select that, I will type the first letter of the first name. Is this possible to do. Or another possibility is to use only last name and first name. So that if I type S, it will show smith and a first name which should come first in the alphabetical order.