View Full Version : MS Access - how to combine several fields in one field

May 6th, 2005, 12:16 AM
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.

Thank You