label wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

daisyn said:
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]
Click to expand...
Click to expand...
 
Back
Top