Capitalization of memo field

[davesmith202]

Is there an easy way to capitalize each word in a memo field?

Dave

 

[boblarson]

Is there an easy way to capitalize each word in a memo field?

Dave

You can

1. Use an update Query and use UCase([YourFieldName]) to do the update.

or

2. You can just use UCase whenever you want to display it.

or

3. When writing to the field, if you are using a form (which I'm hoping you would be) you can use the Control's Before Update event to change it to:

Me.YourTextBoxName = UCase(Me.YourTextBoxName)

 

[davesmith202]

I forgot to mention, only capitalize the first letter of each word! ProperCase or something seems to ring a bell.

I will use something like:

Me.YourTextBoxName = UCase(Me.YourTextBoxName)

but need a ProperCase function.

 

[chergh]

Me.YourTextBoxName = strconv(Me.YourTextBoxName, vbpropercase)

 

[davesmith202]

Fab! Thank you guys.