Convert first letter to Caps

[tMitch]

Hi,

I am trying to convert the 1st letter of a field with 2 words to caps. I don't want vbProperCase because I only want the first word capitalized (it's a botanical name). I've searched through Access Help and the Forum, but haven't found any info on this.

Can someone help with this?

Thank you.

 

[antomack]

Do an update on the field with the following

Ucase(Left([YourFieldName],1)) & Right([YourFieldName],len([YourFieldName])-1)

or if you want to ensure that only the first letter is in upper case then use
UCase(Left([YourFieldName],1)) & LCase(Right([YourFieldName],len([YourFieldName])-1))