upper/lower case letter formatting

  • Thread starter Thread starter Mark
  • Start date Start date
M

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!!!!!!!
 
To get first and last names in solid caps:
="Name: " & UCase([EmployeeFName] & " " & [EmployeeLName])
& " " & "( Emp. ID: " & [EmployeeID] & " ; wk # " &
[WorkPhone] & " ; ext # " & [ExtNumber] & " ) "
Click to expand...

To get mixed case:
="Name: " & StrConv([EmployeeFName], 3) & " " & StrConv([EmployeeLName], 3)
& " " & "( Emp. ID: " & [EmployeeID] & " ; wk # " &
[WorkPhone] & " ; ext # " & [ExtNumber] & " ) "
Click to expand...

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

Mark said:
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!!!!!!!
Click to expand...
 
Try this

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


Rgds,
Glenn
 
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!!!!!!!
.
Click to expand...
.
Click to expand...
 
Back
Top