Label in MS Access

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

Guest

Since I got my new computer and MS Office XP I am not able to print labels
from MS Access. When I bring them up in the print preview instead of the name
and address on the label it says error! on all the lines. The design view is
ok.
 
It could be a References problem (since, AFAIK, the label wizard uses the
Trim function from the VBA library)

Open any code module (or open the Debug Window, using Ctrl-G). Select Tools
| References from the menu bar. Examine all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)
 
Back
Top