Input mask for names ie:Last,First,Middle,

J

James

I would like a mask or code so I may make/create in my form a field for
names. I want to input them as follows: DOE,JOHN,MICHAEL,. I would like
for it to require the commas. Any help would be nice.
 
D

Douglas J. Steele

My recommendation would be to use separate fields for the different parts of
the name, rather than storing the entire name in a single field.
 
F

fredg

I would like a mask or code so I may make/create in my form a field for
names. I want to input them as follows: DOE,JOHN,MICHAEL,. I would like
for it to require the commas. Any help would be nice.
Click to expand...

I doubt that anyone knowledgeable here is going to help you do
something that goes against the rules of Access.

Create 3 separate fields.
One for LastName
One for FirstName
One for Middle name.

It is very easy to put them together in a report, query, or form, i.e.
= FirstName & (" " + MiddleName) & " " & LastName

It is quite a hassle to separate them from a combined field,
especially if some records do not contain all 3 names.
 
J

Jbond122

That is what I was going to do, but the old form that we were using has it
set up this way. So I was tring to keep it the same.
 
J

Jbond122

Thanks, but I must be doing somthing wrong. Or I don't really understand
where I put = FirstName & (" " + MiddleName) & " " & LastName code that you
gave me. I have three seprate fields in a table for last, first, middle
name. I wanted the input mask for form.
 
Top