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

Dave

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)

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.

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

Fab! Thank you guys. :)