I have the fields [FirstName] and [LastName] on my Reports I would like the to show up in one field is there a way to do this?

Thanks!

Antonio

Certainly...

Just set the source of the field to

=[FirstName] & " " & [LastName]

Hope that helps,

Mike

Mike
EchoVue.com

hmmm this doesnt seem to be working and i am not sure why.

I tried:

-Deleting one of the boxes and inserting the control source-
-Inserting the Control source into both Boxes.
-putting the query source infront of the control source =[QuoteQuery].[Firstname] & " " & [QuoteQuery].[LastName]
- Tried doing the same thing with the table.

Any steps i am missing before changing the control source?

Antonio,
Put an unbound textbox down, then into it type "= [firstname] & " " & [lastname]. Then hit enter.

Does that work? If not- What is the name of the datasource for lastname? And what is the name of the control it lastname is in in your form? Same for firstname?

Your my Hero!!!! Thats what it was! I think I need to stop using the wizard for things it makes it much harder to do.

You guys are the Bestest!