Input mask for surname with '

[mdspoc]

Is it possible to set up an input mask for a form for a surname field so that names will show first letter of name as a capital (easy), as in Smith - but for names like O'Connor, show the first and second letters as capitals? (and, of course, allow the ' to be entered).
Thanks.

 

[TedMartin]

For the first letter being a Capital, this is easy.
Put an Input mask on the Table and the Form like >C<????????????????????????????????;; where the ???? is the maximum number of other characters. (Tie this into the field size).

I don't think you are going to be able to do the O'C on the same field unless there is a way I can't immediately think of to have an either/or input mask.

You may have to enter the data into an input box, validate it and then enter it into the from. Maybe all you have to do it look for the ' and then use code in the form to change the input mask to something like >C\'C<????????????????????????????????;;. If you do do it this way, the Table input mask will have to be blank so as not to conflict with the form.

Think laterally and off you go.

Hope this helps.