Thank you for considering my question!
It seems like such a common thing I'm doing here, but I couldn't find an archived apples-to-apples post requesting the same thing. Please suffer me if this question has been answered elsewhere in different wording.
I have a field called Status with the "short text" datatype. Many thousands of records have already been entered in all lowercase.
My job is to simply bind the .ControlSource property of a textbox to this Status field. Easy enough - everything works just fine. Now if only I could get the first letter to be capitalized.
In my foolishness, I tried making the .ControlSource property read:
=StrConv([Status], vbProperCase)
This does not work. I'm not 100% sure why - as an aside, it would be helpful if someone could explain that to me. I'm a bit rusty at this.
I looked through MS documentation on the format property for the textbox. You can put a ">" in this property to make the entire contents of this textbox capitalized. But that doesn't help me any - I only want the first letter capitalized. I couldn't find any easy, predesigned way from MS to do this.
I could always do the StrConv() function as an Expression Field in the Query bound to this Form's recordset, and that will work, but I feel dirty that I can't figure out how to make a simple textbox format correctly.
Tell me I'm missing something obvious?
Thank you!
Matt