Title Case

[Linda]

Hello all!

Can someone tell me how to set up the expression so that
all the first letter of the words typed in a field would
be capitals? Thank you!

Kindest regards,
Linda

 

[RobFMS]

Use the function called StrConv().

Here is a sampling:
-------------------------------------
? strconv("little bo peep has lost her sheep.", vbProperCase)
Little Bo Peep Has Lost Her Sheep.


HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Marin Kostov]

There are two ways:
1. Open the table in design view.
Under the Field Properties, in the Input Mask row type >. That fill force
all characters to be upper-case.
2. If you are working with form, open the form in design view, select the
text box of the field, and in the Text Box Properties Page (You can display
that page after pressing the F4 key), the Format tab, type > in the Format
row.
For other format options, search the Access help for Format Property - Text
and Memo Data Types, and Input mask syntax and examples

 

[Linda]

Thank you Rob and Marin!!