label wizard

[Guest]

When I use the label wizard, anytime I put more that one field on the same
line, the labels come out as #error

example; Mr & Mrs - Jones
1234 Oak Street
city, - state. - zip

come out; #error
1234 Oak Street
#error

 

[Allen Browne]

Change the Name property of the text box. Access gets confused if it has the
same name as a field, but is bound to an expression.

You should then be fine with a Control Source such as:
=[city] & " " & [state] & " " & [zip]

 

[Guest]

What do you mean "change the name property of the text box"? I have the same
problem that Larry has. I changed the text box name to "fullname", where the
control source is =Trim([firstname]& " " &[lastname]) and I still have the
problem - comes out error on the labels.

Change the Name property of the text box. Access gets confused if it has the
same name as a field, but is bound to an expression.

You should then be fine with a Control Source such as:
=[city] & " " & [state] & " " & [zip]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

When I use the label wizard, anytime I put more that one field on the same
line, the labels come out as #error

example; Mr & Mrs - Jones
1234 Oak Street
city, - state. - zip

come out; #error
1234 Oak Street
#error

 

[Allen Browne]

Try placing text boxes for firstname and lastname onto the report.
Set their visible property to No if you wish.
Then try again. If you have change the text box name to fullname, that
should work.

If there is still a problem, try without the Trim(). If that solves the
problem, you have a problem with references. Details:
http://members.iinet.net.au/~allenbrowne/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

What do you mean "change the name property of the text box"? I have the
same
problem that Larry has. I changed the text box name to "fullname", where
the
control source is =Trim([firstname]& " " &[lastname]) and I still have the
problem - comes out error on the labels.

Change the Name property of the text box. Access gets confused if it has
the
same name as a field, but is bound to an expression.

You should then be fine with a Control Source such as:
=[city] & " " & [state] & " " & [zip]