Case Sensitive

[Mahall906]

Morning all,

I think I may be struggling with such a feeble task.

I have a text box within a form and I would like to make it case sensitive, i.e nottingham city become Nottingham City if entered incorrectly.

Is this a simple thing to fix?

Thanks in advance

Marcus

 

[pr2-eugin]

Hello Mahall906, Welcome to AWF

You can use the AfterUpdate event, something like

Private Sub yourTextBoxName_AfterUpdate()
    Me.yourTextBoxName = StrConv(Me.yourTextBoxName, vbProperCase)
End Sub

 

[Mahall906]

Awesome!! Thanks that is great thank you!!

 

[pr2-eugin]

You're welcome ! Good Luck !