First Character to Lowercase

[roccogrand]

In the resumes module of my proposal database I need to concatenate a
person's job title with their job descriptions and with the text "As " and a
comma in a few of my reports. Because the job descriptions all start with
capital letters, I need a way to change the first letter of a Memo
(JobDescription) field to lowercase. The best query that I have been able to
do this is:

="As " & [JobTitle] & ", " & LCase(Left([JobDescription],1)) &
Mid([JobDescription],2,1000)

Is there a better way to do this? It's the only way that I have come up
with to create a grammatically correct sentence.

I use 1000 to limit the amount of text because that's about the largest
number of characters that the job description field will ever contain. I
can't force the first letter of each job description to be lower case because
the same text is used in other job descriptions where the first character
must be upper case. In fact, I use text from the resumes table in about ten
formatted reports depending on the type of resume I need.

Thanks.

David

 

[Douglas J. Steele]

The third argument in the Mid function is actually optional.

Just use

="As " & [JobTitle] & ", " & LCase(Left([JobDescription],1)) &
Mid([JobDescription],2)

 

[roccogrand]

Thanks Douglas.

David

The third argument in the Mid function is actually optional.

Just use

="As " & [JobTitle] & ", " & LCase(Left([JobDescription],1)) &
Mid([JobDescription],2)


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

In the resumes module of my proposal database I need to concatenate a
person's job title with their job descriptions and with the text "As " and
a
comma in a few of my reports. Because the job descriptions all start with
capital letters, I need a way to change the first letter of a Memo
(JobDescription) field to lowercase. The best query that I have been able
to
do this is:

="As " & [JobTitle] & ", " & LCase(Left([JobDescription],1)) &
Mid([JobDescription],2,1000)

Is there a better way to do this? It's the only way that I have come up
with to create a grammatically correct sentence.

I use 1000 to limit the amount of text because that's about the largest
number of characters that the job description field will ever contain. I
can't force the first letter of each job description to be lower case
because
the same text is used in other job descriptions where the first character
must be upper case. In fact, I use text from the resumes table in about
ten
formatted reports depending on the type of resume I need.

Thanks.

David

.