Receiving #error when creating mailing label using label wizard

D

Dee_Dee

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

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
 
D

Dee_Dee

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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top