How to convert a string to proper case

Dean Isensee 20 Reputation points
2026-06-09T10:44:36.7733333+00:00

How do I convert a string to proper case? eg samson to Samson

Microsoft 365 and Office | Access | For home | Windows
Answer accepted by question author
Karl Donaubauer 3,661 Reputation points MVP
2026-06-09T13:40:05.65+00:00

Hi,

StrConv("samson",3)

or

StrConv([YourFieldName],3)

Servus
Karl

Access Forever News DevCon
Access-Entwickler-Konferenz AEK

Was this answer helpful?

2 people found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. AI answer

    2026-06-09T10:44:51.7633333+00:00

    In Microsoft 365 apps, use the built-in “proper case” functions to convert strings like samson to Samson.

    In Excel (including Access expressions that use Excel-style functions):

    • Use the PROPER function:
      • =PROPER("samson") returns Samson.
      • For a cell value, e.g. A2, use =PROPER(A2).

    In Power Query (Power Query M):

    • Use Text.Proper:
      • Text.Proper("samson") returns Samson.

    In Power Apps (Power Fx):

    • Use Proper:
      • Proper("samson") returns Samson.

    In .NET code (for Office add-ins or automation):

    • Use TextInfo.ToTitleCase for title/proper case, or String.ToUpper/String.ToLower for full-case changes.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.