Microsoft Office 2000 Access

  • Thread starter Thread starter Suzanne
  • Start date Start date
S

Suzanne

I can't find how to put a new field for Mr., Ms., Mrs.
before my First Name field in my database. I have already
entered in 50 entries. I used the Wizard and I have a
Switchboard. Help...
 
I can't find how to put a new field for Mr., Ms., Mrs.
before my First Name field in my database. I have already
entered in 50 entries. I used the Wizard and I have a
Switchboard. Help...
Click to expand...

Open the Table in design view; add a new field named Title, Text type,
and reasonably short (12 bytes maybe so you can add military titles,
frex).

If you have a Form that you're using to enter data, you can now open
the form in design view, and add a Combo Box to the form (anywhere on
the form you like, such as before the first name). Set its Row Source
Type to Value List and enter the titles that you want in the Value
List property, e.g.

"Ms.";"Mrs.";"Mr.";"Dr.";"Rev."
 
Back
Top