Proper Noun

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

Guest

I'm trying with no success to capitalise the first letter of a name using the
exspression builder.
ie. Regardless of how the Last Name is entered, in the concatenated field I
want the Last name to display as follows;
smith or SMITH = Smith
 
One way
UCase(Left([Last Name],1)) & Mid([Last Name],2)

or use the StrConv function

StrConv([Last Name],3)
 
Back
Top