label wizard

L

larry

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
 
A

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]
 
D

daisyn

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.


Allen Browne said:
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.

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