prints error when it shows something on PC

[associates]

Hi,

This is a weird one. I'm working on an Access application 2003. I have one report that has a textbox that has a control source as follows

="Filter: System " & [Forms].[qfProjects].[TB_System_Data] & " : Project Code " & [Forms].[qfProjects].[TB_Project_Code_Data] & " : Project Name " & [Forms].[qfProjects].[TB_Project_Name_Data] & " : CHW Project " & [Forms].[qfProjects].[TB_J_ID_Data] & " : Plan ID " & [Forms].[qfProjects].[TB_PN_ID_Data]

The wierd thing is that it actually shows something in the report. I mean there is a value in there as follows

Filter: System *: Project Code C: Project Name *: CHW Project *: Plan ID WQQ111

But when printing out, it shows the following

#Name?

what on earth is happening? i can't find any rational reason for this to happen. Should it not show what you see on the computer when printing it out to the printer? is it to do with the code?

I need your help.

Thank you in advance

 

[pbaldy]

The form would still need to be open when the report prints (not just when it previews). Is it?