Concatenate in a textbox

[stephanieleshk]

I'm trying to put both lastname and first name in a text box. This it the code I'm using in the control source for the textbox

=[Last] & ", " & [First]

I keep getting #Error when I run the report!
Any idears?
Thanks,
Stephanie

 

[boblarson]

I have no idears, but I do have an idea:

Make sure

1. Your text box doesn't have the same name as either last or first. (90% of the time this is the problem)

2. Make sure your field names are truly last and first

3. Make sure that your underlying query doesn't have the possibility that last and first are in more than one table of the query, otherwise you will have to specifiy which to use.

 

[stephanieleshk]

That did it!

I think the textbox name was conflicting with the field name! Thanks so much!!!!

 

[gnarpeggio]

Concatenate in a text box...

What if you're trying to use fields not associated with the Record Source? I'm trying to concatenate a First Name and Last Name from my Staff table on a form that uses a query result.

For example, I've tried SQL...

=(SELECT FirstName & " " & LastName FROM Staff)

All I get is the #Name? error. Can this be done?

Thanks!