Input Mask to Require First and Last names

[justair07]

Hello,



Does anyone know the code I need to enter into the Input Mask Wizard so data entered is required to have First and Last name and be capitalized? For example: "John Doe"

Thank you,

Btw I'm very new to Access and am learning

-justair

[RuralGuy]

The First and Last names should be in different fields. You can *always* put them back together. As for capitalization, let the user do whatever they want and fix it in the AfterUpdate event using the StrConv() function.

[June7]

Input mask not appropriate for variable data like names. There is no consistent pattern.

You can use code in textbox AfterUpdate event to correct the input for capitalization using StrConv() function.

EDIT: RG got in first this time.

[justair07]

Ok will do, thank you for the tip guys

[RuralGuy]

Always glad to help.