Receiving #error when creating mailing label using label wizard

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

 

[Mike Labosh]

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.

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

 

[Guest]

Thanks for your help Mike, I'll go back and check all field names in each of
my tables

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.

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