#ERROR - but query fine

  • Thread starter Thread starter leahf via AccessMonster.com
  • Start date Start date
L

leahf via AccessMonster.com

I have want to print labels. When the query is run all the fields (name,
address, city, zip) are fine. When I run the actual report that prints the
label, the address comes out as #ERROR.

Can anyone help?

Leah
 
I just changed the label of the text box and everything is fine. Apparently
one can't use the same name as the field or there was some kind of bug.

Thanks for anyone who might have tried to help.
Leah
 
I believe that the field may have the same name as the field in the
recordsource,
but when you change the datasource of let's say [FamName] into e.g
=[FirstName] & [FamName]
then Access gets confused and then you'll have to rename it.

michiel
 
Thanks for the info.

Leah
I believe that the field may have the same name as the field in the
recordsource,
but when you change the datasource of let's say [FamName] into e.g
=[FirstName] & [FamName]
then Access gets confused and then you'll have to rename it.

michiel
I just changed the label of the text box and everything is fine.
Apparently
Click to expand...
[quoted text clipped - 11 lines]
Click to expand...
 
Back
Top