combine last name and first name

[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

 

[Allen Browne]

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

 

[Bob76]

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

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.

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

 

[Allen Browne]

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.)

 

[Bob76]

That's great, Allen.... Did it.... thanks a lot