Input Mask Does not Work As Expected in Access

[Abhaa]

I am not an Access specialist; however I can make use of it quite fine. My trouble is that I have an HR database furthermore I would like to make use of an Input Mask intended for the last name field with the intention that the user will not have to make use of the upper case. Fine, certainly, the input mask is not superior for that since we have a lot of with two last names as well as suffixes furthermore the mask cannot address those circumstances. I have found some code on the way to address this which was specified out on the internet; however I do not know where to place it. Can you please assist me with this? Thanks a lot.

[GeforceUser]

It is relevant to the table only if the table or else a query based on it are making used as the record source of the form. The On Current is a Form event as a result you require to click on the form's background on the way to get the form consequences or else open the form inside design mode. If Access cannot discover the object name you require to watchfully verifying the name of the Field you are attempting to work by. Can you tell me what is the name of your field on the form?

[Abhaa]

Thank you for your valuable suggestion. I have read someplace that the controls on the form did not apply to the table. I found On Current. I am trying to set the properties for the individual field in the form. I have entered the following: LastName = StrConv( LastName, vbProperCase).The field in the table is set up as Last Name. It illustrates as that in the fields in Queries, Forms as well as Reports. Do I require making a Function or else Macro first? At what time I click on Help in the Error Message I obtain this information:Access was not capable to position the macro or else VBA function. If you are attempting to call a macro, ensure that the name of the macro and the name of the macro collection are spelled appropriately.

[DotNetUser]

If you indicate an Input Mask, after that you be supposed to extra input mask control characters on the way to inform Access what characters are allowable. Just having a ">" as an Input Mask will not function, for the reason that you have no characters permit input.If you are attempting to identify an Input Mask for Canadian, after that you may need the user to indicate the Country field primary (i.e., have the ZIP code field empty as well as locked until Country is detailed).

[Gunilla]

The code does not go inside the event line. The VBA code does not go in the Line which states event process, what you require to perform is Cut that portion of code as of from the event line. After that click the drop down as well as choose "Event Procedure", three small dots will come into sight on the right hand part, click on the dots furthermore it will open the VBA Editor at the Combo's "After Update" event process. You will need to make use of me.[EndName] = StrConv(me.[EndName], vbProperCase)