proper case

hsdaguilar · Jul 12, 2005

Hello,

I realize that propercase is similar to titlecase in word in that it
capitalizes the first letter in each word. Does access also have the
equivalent to sentence case, where it would only capitalize the first letter
in each sentence?

Rick Brandt · Jul 12, 2005

hsdaguilar said:
Hello,

I realize that propercase is similar to titlecase in word in that it
capitalizes the first letter in each word. Does access also have the
equivalent to sentence case, where it would only capitalize the first
letter in each sentence?

No. You would have to write a custom function.

hsdaguilar · Jul 12, 2005

Ok, thank you. Would you mind showing me how?

Rick Brandt said:
No. You would have to write a custom function.

Rick Brandt · Jul 13, 2005

hsdaguilar said:
Ok, thank you. Would you mind showing me how?

Do a Google search on...

"sentence case function group:*access*"

....and you should get a few ideas.

hsdaguilar · Jul 13, 2005

Found it. Thx.

Rick Brandt said:
Do a Google search on...

"sentence case function group:*access*"

....and you should get a few ideas.