#ERROR - but query fine

[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

 

[leahf via AccessMonster.com]

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

 

[Michiel Rapati-Kekkonen]

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

 

[leahf via AccessMonster.com]

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

[quoted text clipped - 11 lines]