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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
Check out the StrConv function in Help file. But it's not foolproof and not
omniscient -- it would write "Macdonald" instead of "MacDonald", etc.
 
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
@<
Click to expand...

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".
 
Back
Top