How to modify a name list

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

I am making a name list for a report. I would like to
make the report show First and Last Names of persons.
However, I do not know the expressions to make the names
appear as John Doe. Using the wizard, the names come up
as John Doe. How do I bring the two names together?
 
Put a control on your report named txtFullName. It can replace the controls
for FirstName and LastName.

Then, in the Control Source property for txtFullName, enter the following:

=Trim(FirstName) & " " & Trim(LastName)

Of course, change the field names for FirstName and LastName to correspond
with the field names you are using.
 
Place a new control on the report that is not named the same
as either of your name fields. Now use this as the control
Source, changing my naming to reflect yours...

For John Doe...
=[FirstName] & " " & [LastName

For Doe, John
=[LastName] & ", " & [FirstName]

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top