Input Mask (1 Viewer)

[Lyncroft]

I've a form with an input mask for Surname. The mask is >L<?????????????. The problem is when someone wants to type in O'Reilly for instance it won't accept the '. Is there any way around this.

Thanks in advance

 

[DBL]

You could handle it slightly differently. You could let the user enter the surname in any format they want and then convert it to uppercase after they have updated the field.

On the AfterUpdate event of the field put:

Me.yourfieldname = UCase(Me.yourfieldname)

 

[Lyncroft]

DBL - Thanks for that. It gets round the apostrophe problem nicely. Unfortunately it makes the whole word upper case. I just want the first letter upper case as in Fox. In the case of O'Reilly I'm not fussed if the R remain lower case.

Any ideas

 

[lorenzoaj]

I use this in the after update of my text box. It changes the first letter to capital.


Me!YourFieldName = fProperCase(Me!YourFieldName)

AJ

 

[DBL]

Sorry Lyncroft, missread your original post, hope lorenzoaj's suggestion has solved it for you.