1st character in CapsLock

[Guest]

Hello!

I would like to know if is possible, in form or report, to get the first
caracter in capital letter, independently to have been written in capital or
small letter.

Thanks in advance.
an

 

[Guest]

In the query that the report (or form) is based on create a field named
Captial (or something like that). Assuming that your query already has a
field named "1stname" insert the following into the new field
Capital: Left([1stName],1)
Hope this helps
Wayne

 

[Guest]

If you already have the 1st name inserted into a form you could simply refer
to it with a new (unbound text box) and set the input mask on the new box to

L<??????????????????????????;0; (this assumes that your 1st name has not

more letter than the number ???'s)

Wayne

 

[Douglas J Steele]

Just the first letter, or the first letter of each word?

For just the first letter, try UCase(Left([MyTextValue],1)) &
LCase(Mid([MyTextValue], 2)) as a computed field in the query that makes up
the form or report's recordsource.

For the first letter of each word, try StrConv([MyTextValue], 3)

 

[Guest]

D J S,

Perfect.
Thanks for your help.
an

Just the first letter, or the first letter of each word?

For just the first letter, try UCase(Left([MyTextValue],1)) &
LCase(Mid([MyTextValue], 2)) as a computed field in the query that makes up
the form or report's recordsource.

For the first letter of each word, try StrConv([MyTextValue], 3)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hello!

I would like to know if is possible, in form or report, to get the first
caracter in capital letter, independently to have been written in capital or
small letter.

Thanks in advance.
an