Proper Noun

V

VBAD

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
 
J

John Spencer (MVP)

One way
UCase(Left([Last Name],1)) & Mid([Last Name],2)

or use the StrConv function

StrConv([Last Name],3)
 
Top