Merging Label Controls?

  • Thread starter Thread starter w2wm via AccessMonster.com
  • Start date Start date
W

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?
 
w2wm said:
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.
Click to expand...


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
 
Marshall,
Thank you! .caption is all I needed! Works great!! Thanks again for your
time!!
-William :-)

Marshall said:
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.
Click to expand...

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
Click to expand...
 
Back
Top