How do I format Title case in Access such as: John Doe?

[Guest]

Using Access 2003 I've created a table with 3 fields: ExaminerNo, FirstName,
LastName. How can I format FirstName and LastName fields to display text as
Title case, with first letter as capital letter and remainint letters lower
case e.g., Linda(FirstNameField) Williams (LastNameField). I've been
searching MS Online, VBA newsgroups, etc. for 4 days! I really need help?
Where can I find a list of common format properties for Access 2003?
My email: (e-mail address removed)

 

[Ken Snell \(MVP\)]

Check out the StrConv function in Help file. But it's not foolproof and not
omniscient -- it would write "Macdonald" instead of "MacDonald", etc.

 

[Van T. Dinh]

If you want to update/store the names in the Table with the correct
(proper-case), use the StrConv() function in an UPDATE Query. Check Access
VB Help on this function with conversion argument vbProperCase = 3 (in the
Query, you need to use 3 rather than the symbolic constant.

If you want to leave the values in the Table as they are but want to display

@<

which forces the first character to upper-case and the rest lower-case.
This, of course, won't work if you want to display the combined FirstName
LastName in the same TextBox.

Check Access Help topic "Format Property - Text and Memo Data Types".