combine last name and first name

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob76" wrote in message
...
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

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" wrote:

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
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob76" wrote in message
...
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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob76" wrote in message
...
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...

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

"Allen Browne" wrote:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob76" wrote in message
...
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...