Printing Labels in Access 2002

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I am tring to create some labels from a customer table in
access. I can use the wizard to create the label report
but the report name shows up on the first line of the
label. What am I missing?
 
My guess is that your have the Field "Name" in the Form's RecordSource and
when you use "Name" in the Report, Access actually use the Report Name
rather than your Field "Name".

That's why "Name" is a bad choice for a Field name since virtually all
objects in Access have an inbuilt Property "Name". If you can, change the
Field name "Name" to something else. I not, use qualify references like:

* Report!Name


in ControlSources of your TextBoxes.

* Me!Name

in VBA code.
 
Back
Top