Input mask help

[TylerTand]

I am trying to create an input mask for a name field. I have Spanish names with two last names separated by a hyphen, a comma after the two last names, a space, and then the First Name a space and the Middle Name. The First Last Name needs to be in all capitals like the example. Example: NARANJO-Ramirez, Jose Luis

Can someone please help me format this mask. One trick is that there aren't always middle names. Since all parts of the name are different lenghts for everybody, I need to have an optional number of characters for each of the four parts of the name.

Thanks for your help.

 

[statsman]

Is it necessary to do it like this?
Can't you have separate fields for each name?
LastName
FirstName
MiddleName

 

[cat001969]

fields in tables should be the smallest possible value, Name is never a good field because it can be broken down further ... in your case you should have:
LastName
LastName2
FirstName
MiddleName

You can then concatinate them in any form, query, or report to have them show as you would want them formatted to read.