Title

  • Thread starter Thread starter RecordGirl
  • Start date Start date
R

RecordGirl

I have a names table; all names begin with Dr. XXXX. When I go to
forms, I have to type in Dr. then begin with the name. Of course, Dr.
pops up after I type the D. How do I make Dr. auto appear in the box
and then begin typing the name and have the rest of the name pop up?
It makes sense that I will have to redo my table and remove Dr. from
all names. Can anyone help with the rest? Thanks.
 
I'm no ACCESS guy, but the one thing I've learned is keeping it simple saves
lives ... if every name begins with Dr. don't include DR in the table, just
list the name itself, then when you want to produce (Dr.) later; in a report,
form, etc, just add it as a separate text box since every name will include it

do you follow?
 
RecordGirl said:
I have a names table; all names begin with Dr.
Click to expand...

If that rule is never broken then don't store "Dr" at all. When you query
the field, use

"Dr. " & [MyNameField]

where "MyNameField" is the name of the field where the name is stored.

Keith.
www.keithwilby.com
 
I'm no ACCESS guy, but the one thing I've learned is keeping it simple saves
lives ... if every name begins with Dr. don't include DR in the table, just
list the name itself, then when you want to produce (Dr.) later; in a report,
form, etc, just add it as a separate text box since every name will include it

do you follow?

Yes, I do. Thanks.



- Show quoted text -
Click to expand...
 
I have a names table; all names begin with Dr. XXXX. When I go to
forms, I have to type in Dr. then begin with the name. Of course, Dr.
pops up after I type the D. How do I make Dr. auto appear in the box
and then begin typing the name and have the rest of the name pop up?
It makes sense that I will have to redo my table and remove Dr. from
all names. Can anyone help with the rest? Thanks.
Click to expand...

I'd be inclined to atomize this name field. Rather than "Dr. John W. Vinson"
it would make more sense to have fields Title, Firstname, Middlename, Surname,
and Suffix (for Jr. or III). They can easily be concatenated for display, and
it gives you the freedom to sort by surname (or firstname), and to show
"Vinson, John" or "John W. Vinson" or "Dr. John W. Vinson" in different
contexts as appropriate.

It would not be too hard to write an update query to split this single name
field into its components.
 
Back
Top