Format String 2

[dbero]

Hello:

Is there a relatively simple method to convert a manually entered text box value from "smith" to "Smith"? I have an oracle back-end and need the leading character to be ucase.

Thank you,

 

[jebry]

Hi!

Try this:

Me!YourTextBox.Value = Format(Me!YourTextBox.Value, vbProperCase)

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[Golom]

Jeff

I think it's

Me!YourTextBox.Value = [red]StrConv[/red](Me!YourTextBox.Value, vbProperCase)

 

[jebry]

Hi!

You're right Golom! I got my conversions mixed up!!

Thanks for the correction!



Jeff Bridgham
Purdue University
Graduate School
Data Analyst