Merging Label Controls?

[w2wm via AccessMonster.com]

Is there any way to merge label controls together into a text box on a report?
I have tried the same thing I do for fields but it doesn’t work. Here is
what I tried =[Last Name_Label] &â€, “&[FirstName_Label] I just end of with an
error. I am not sure if this is possible. Any ideas?

 

[Marshall Barton]

Is there any way to merge label controls together into a text box on a report?
I have tried the same thing I do for fields but it doesn’t work. Here is
what I tried =[Last Name_Label] &”, “&[FirstName_Label] I just end of with an
error.

Where are the label's captions coming from?

Ordinarily, they are static because you typed the captions
in the report's design. In this case you can just use
another label and type the combined name.

If the captions are coming from some dynamic source (e.g.
fields in the report's record source table/query), then why
not just set a label with the combined name at the same
time.

Yo answer your specific question, you need to refer to the
label's Caption property because labels don't have a Value
property.

=[Last Name_Label].Caption &”, “&[FirstName_Label].Caption

 

[w2wm via AccessMonster.com]

Marshall,
Thank you! .caption is all I needed! Works great!! Thanks again for your
time!!
-William

Is there any way to merge label controls together into a text box on a report?
I have tried the same thing I do for fields but it doesnÂ’t work. Here is
what I tried =[Last Name_Label] &”, “&[FirstName_Label] I just end of with an
error.

Where are the label's captions coming from?

Ordinarily, they are static because you typed the captions
in the report's design. In this case you can just use
another label and type the combined name.

If the captions are coming from some dynamic source (e.g.
fields in the report's record source table/query), then why
not just set a label with the combined name at the same
time.

Yo answer your specific question, you need to refer to the
label's Caption property because labels don't have a Value
property.

=[Last Name_Label].Caption &”, “&[FirstName_Label].Caption