Proper case in a field 1

[sansangtracao]

Please tell me what code to be put on a field that on exit every thing will be in capital case? Thanks very much!

 

[PHV]

every thing will be in capital case
Have a look at the UCase function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sansangtracao]

Hi, I'm kinda dumb in the MS Access and trying to put things together. Can you tell me m?e about this?????

 

[TheAceMan1]

How are ya sansangtracao . . .

You can also try the [blue]StrConv[/blue] function:

[blue]   Me!TextboxName = StrConv(Me!TextboxName, vbUpperCase)[/blue]

and PHV's suggestion:

[blue]   Me!TextboxName = UCase(Me!TextboxName)[/blue]

In any module, type [blue]UCase[/blue] or [blue]StrConv[/blue]. Put the cursor within the word and hit [blue]F1[/blue] to read about it. To get the info on an event, put the cursor on the event line and hit [blue]F1[/blue]. [purple]Its called context sensitive help.[/purple]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886