Input Mask

[Guest]

I have entered an input mask in the proprties of several tables
(>L<CCCCCC;;_) to insure 1st letter upper case and remaining characters
lowercase. when inserting field into a form and entering data, the mask is
not in affect. Where did I go wrong?

 

[Wayne Morgan]

The mask in the table will only transfer to a control on the form if you
create the control in a specific way. You have to create the mask in the
table first, open the form in design mode, open the field pick list, and
drag and drop the field onto the form. If you create the control on the form
any other way, you'll need to enter the input mask into the control's
properties while in design view of the form.