Forcing specific text format. 2

[eon5]

Hi,
Im using the following code to change text format to Capitals.

"production plan"
"PRODUCTION PLAN"


If KeyAscii > 96 And KeyAscii < 123 Then
KeyAscii = (KeyAscii And 223)
End If
End Sub

Is there any other way of coding so that it will only change the Firts letter to Capital format. It will look much neater and also easier for the client to read and in the same breath make the typing faster.

"Production Plan" is better than
"PRODUCTION PLAN"

Thanks
eon5

 

[PHV]

Have a look at the StrConv function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ProgramError]

Take a look at the UCase(string) function. It's a lot simpler.

Ian Mayor (UK)
Program Error
If people say I have bad breath, then why do they continue to ask me questions and expect me to answer them?