If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#ERROR - but query fine
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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200803/1 |
#2
|
|||
|
|||
#ERROR - but query fine
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 leahf wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200803/1 |
#3
|
|||
|
|||
#ERROR - but query fine
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" u13396@uwe wrote in message news:80e5d1af82b2f@uwe... 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 leahf wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200803/1 |
#4
|
|||
|
|||
#ERROR - but query fine
Thanks for the info.
Leah Michiel Rapati-Kekkonen wrote: 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] Leah -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|