combine last name and first name

  • Thread starter Thread starter Bob76
  • Start date Start date
B

Bob76

I have the employee name separated by LastName & FirstName (2 separate
columns) in my TblEmployee. In my report, would like to combine the last and
first names into 1 column... ex. Smith, John
How do I do this?
Thanks, Bob76
 
Set the Control Source of the text box to:
=[LastName] & ", " + [FirstName]

Make sure the Name property of this text box is not the same as a field,
e.g. it cannot be Lastname or FirstName
 
Thanks a lot... after several errors, finally did it... am a novice at
Access, just learning from books and help from this Discussion Group.

Have another question: the report view shows the data in boxes, while the
labels are not in boxes.. I want them to print out like a spreadsheet...

Went to Design view and selected both the labels and data, but the GRIDLINES
option in the Ribbon is grayed out.. Please help

Thanks, BOB76


Allen Browne said:
Set the Control Source of the text box to:
=[LastName] & ", " + [FirstName]

Make sure the Name property of this text box is not the same as a field,
e.g. it cannot be Lastname or FirstName

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Bob76 said:
I have the employee name separated by LastName & FirstName (2 separate
columns) in my TblEmployee. In my report, would like to combine the last
and
first names into 1 column... ex. Smith, John
How do I do this?
Thanks, Bob76
Click to expand...
Click to expand...
 
Select all the boxes (click and hold outside them, and drag over them), and
use the Line Color icon (towards the right on the Controls chunk of the
Design ribbon.)
 
Back
Top