upper/lower case letter formatting

[Mark]

Good morning to all,

I have a question. On a report, I have a text box with
the following control source entry:

="Name: " & [EmployeeFName] & " " & [EmployeeLName]
& " " & "( Emp. ID: " & [EmployeeID] & " ; wk # " &
[WorkPhone] & " ; ext # " & [ExtNumber] & " ) "

....which displays something like this:

Name: mark smith (Emp. ID 111 ; wk # (555)555-5555 ; ext
# )

I would like to have the employee first and last name to
be upper case letters. I know if I have the employee
first/last name in one text box and the remaining info in
another text box... I could then type ">" in the format
line of the properties box to have upper case letters
return for the employee name, but I would like to keep all
this code together. Is this possible? And on that note,
how could I get the first letter of the first and last
name to be upper case and the rest of the letters lower
case?

Thanks for any insite you might have!!!!!!!

 

[Cheryl Fischer]

To get first and last names in solid caps:

="Name: " & UCase([EmployeeFName] & " " & [EmployeeLName])
& " " & "( Emp. ID: " & [EmployeeID] & " ; wk # " &
[WorkPhone] & " ; ext # " & [ExtNumber] & " ) "

To get mixed case:

="Name: " & StrConv([EmployeeFName], 3) & " " & StrConv([EmployeeLName], 3)
& " " & "( Emp. ID: " & [EmployeeID] & " ; wk # " &
[WorkPhone] & " ; ext # " & [ExtNumber] & " ) "

The StrConv() function with the 3 argument (for ProperCase) will correctly
convert most - but not all - names. For example,

StrConv("MACGREGOR", 3) will convert to Macgregor
StrConv("jp williams", 3) will convert to Jp Williams

hth,



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Good morning to all,

I have a question. On a report, I have a text box with
the following control source entry:

="Name: " & [EmployeeFName] & " " & [EmployeeLName]
& " " & "( Emp. ID: " & [EmployeeID] & " ; wk # " &
[WorkPhone] & " ; ext # " & [ExtNumber] & " ) "

...which displays something like this:

Name: mark smith (Emp. ID 111 ; wk # (555)555-5555 ; ext
# )

I would like to have the employee first and last name to
be upper case letters. I know if I have the employee
first/last name in one text box and the remaining info in
another text box... I could then type ">" in the format
line of the properties box to have upper case letters
return for the employee name, but I would like to keep all
this code together. Is this possible? And on that note,
how could I get the first letter of the first and last
name to be upper case and the rest of the letters lower
case?

Thanks for any insite you might have!!!!!!!

 

[Glenn]

Try this

="Name: " & strConv([EmployeeFName],3) & " " & strConv
([EmployeeLName] ,3)
& " " & "( Emp. ID: " & [EmployeeID] & " ; wk # " &
[WorkPhone] & " ; ext # " & [ExtNumber] & " ) "


Rgds,
Glenn

 

[Mark]

Thanks a bunch Glenn and Cheryl for the quick response and
the great help!!!!!!!! have a good friday!!!!!!!!

-----Original Message-----
Try this

="Name: " & strConv([EmployeeFName],3) & " " & strConv
([EmployeeLName] ,3)
& " " & "( Emp. ID: " & [EmployeeID] & " ; wk # " &
[WorkPhone] & " ; ext # " & [ExtNumber] & " ) "


Rgds,
Glenn

-----Original Message-----
Good morning to all,

I have a question. On a report, I have a text box with
the following control source entry:

="Name: " & [EmployeeFName] & " " & [EmployeeLName]
& " " & "( Emp. ID: " & [EmployeeID] & " ; wk # " &
[WorkPhone] & " ; ext # " & [ExtNumber] & " ) "

....which displays something like this:

Name: mark smith (Emp. ID 111 ; wk # (555)555-5555 ; ext
# )

I would like to have the employee first and last name to
be upper case letters. I know if I have the employee
first/last name in one text box and the remaining info in
another text box... I could then type ">" in the format
line of the properties box to have upper case letters
return for the employee name, but I would like to keep all
this code together. Is this possible? And on that note,
how could I get the first letter of the first and last
name to be upper case and the rest of the letters lower
case?

Thanks for any insite you might have!!!!!!!
.

.