capitalize text on field entry in form

[tweety]

Is there a way of capitalizing text into a field? so once you type so text into a field, It Looks Like This?



Its so the the name fields have the first and last name starts uppercase and the rest lower case

also to convert the whole field to upper case, such as zip code or post code

thanks

[alansidman]

Initial caps:
In your table, in the properties for the field in question, set the input mask as >L<????????????

All CAPS:

Set the mask to >L

[tweety]

By using this input mask only the first letter is upper case >L<???????????

if i have in one field 2 or 3 words e.g Access forums, i would like it to display it like Access Forums

Any Ideas? Thanks

[Missinglinq]

Sure! You can use the StrConv Function with the vbProperCase Parameter:

Private Sub ControlName_AfterUpdate()
  Me.ControlName = StrConv(Me.ControlName, vbProperCase)
End Sub

Linq ;0)>