Change case in a control of a report

[glwoolley]

Data coming in from a linked table is formated "LNAME, FNAME". In a report,
I need the data to appear "Fname Lname"
How can I change the order and case format?

 

[Rick B]

What about Billy bob Thornton? "B"ob

Or Susan O'malley? "Malley"

Or Dick Van dyck? "Dyck"

Or Carmen San diego? "Diego"



You need to store the data properly in the tables. You can't do this
through code with names. Too many variables.



Rick B

 

[fredg]

Data coming in from a linked table is formated "LNAME, FNAME". In a report,
I need the data to appear "Fname Lname"
How can I change the order and case format?

Use an unbound control in the report.
Set it's control source to:


= StrConv(Mid([CombinedNames],InStr([CombinedNames],",")+2),3) & " " &
StrConv(Left([CombinedNames],InStr([CombinedNames],",")-1),3)

SMITH, ROBERT
Robert Smith

This will not properly capitalize names which should have more than
one capital, i.e. O'Brien, MacGregor become O'brien and Macgregor,
etc., and will incorrectly capitalize names that should not be
capitalized, i.e. van den Steen becomes Van Den Steen.