Receiving #error when creating mailing label using label wizard

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

Guest

Using Access 2000. Trying to create mailing labels using label wizard. The
finished labels appear with #error where the name should appear. Can anyone
help? Thanks.
 
Using Access 2000. Trying to create mailing labels using label wizard.
The
finished labels appear with #error where the name should appear. Can
anyone
help? Thanks.
Click to expand...

I've seen this #Error thing only when a data binding is broken, like, if the
column in the base table is called "FName" but the control source of the
control says "FirstName".

Since you used the wizard, it would seem that the data bindings shouldn't be
wrong, but you might check the control source against the column name once
more. Sometimes the wizard forgets to put [square brackets] around things
that have spaces in their names.
--
Peace & happy computing,

Mike Labosh, MCSD

"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane
 
Thanks for your help Mike, I'll go back and check all field names in each of
my tables

Mike Labosh said:
Using Access 2000. Trying to create mailing labels using label wizard.
The
finished labels appear with #error where the name should appear. Can
anyone
help? Thanks.
Click to expand...

I've seen this #Error thing only when a data binding is broken, like, if the
column in the base table is called "FName" but the control source of the
control says "FirstName".

Since you used the wizard, it would seem that the data bindings shouldn't be
wrong, but you might check the control source against the column name once
more. Sometimes the wizard forgets to put [square brackets] around things
that have spaces in their names.
--
Peace & happy computing,

Mike Labosh, MCSD

"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane
Click to expand...
 
Back
Top