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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Fill Word Documents 4
Grouping Names in Mail Merge 0
Concatenate multiple records 3
Mail Merge - List multiple items then page break on unique data 1
Query help...some criteria or none 2
Multiple records in table to display single records 7
Using Prompt with a "like" query parameter 2
Trim Last Name 1

Top