To add to Wayne's answer, check for missing references, especially if your report (mailing
labels) worked okay with a prior version of Access:
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
Access can fail in weird ways when you have a missing reference. The mailing label wizard
includes the use of the Trim function in the control source of one of the text boxes.
Trim is a VBA function. This function can fail if ANY reference is marked as missing.
Check your code for reference priority problems, which are caused by not fully qualifying
the library that is used. See the following KB article for an example:
http://support.microsoft.com/?id=181542
Tom
______________________________________
Upgraded from ....? Are the names a column of labels (i.e. names for the
data) or data that contains names? Are you seeing #Error in a textbox? If
so, what is the control source of that textbox? Is any of the label(s)
working correctly? Do you get any other error messages?
--
Wayne Morgan
Microsoft Access MVP
______________________________________
I've upgraded to Access 2002 and am now having trouble
making labels from my database. I get error messages in
the columns where the names should be. Any
ideas...help...would be appreciated.
