Text Box Format

[Beenz75]

Hi,

On text box properties, Format tab, Format box

I type 'greater than' (>) symbol to get CAPS text or (<) for lower text.

What I really want is Title text, is there a symbol for this?

Thank you

 

[missinglinq]

Not familiar with the term "Title text" but I'm guessing from your statements that you want the first letter of each word capitalized. You can use the StrConv function and vbProperCase to accomplish this. The code below utilizes this and allows you do to this to multiple textboxes, by simply placing the line

ChangeCase

in each box's AfterUpdate event and add the ChangeCase() sub to your form's code.

Private Sub YourTextBoxName_AfterUpdate()
  ChangeCase
End Sub

Sub ChangeCase()
  Screen.ActiveControl = StrConv(Screen.ActiveControl, vbProperCase)
End Sub

If this is not what you mean by "Title Text" post back with a clearer explanation.

Good Luck!

 

[Beenz75]

Hi, that was exactly what I meant, sorry if that is not the proper term for it.
I have'nt used the _AfterUpdate () before but your post was very easy to understand. I had a play about with it and (eventually!) got it to work!!

This is great!, this will make the input of the form so much better now. Thank you very much, you are so clever.

Graeme

 

[missinglinq]

Glad I could help! ;0)>