#size error on print preview (1 Viewer)

[cktcPeterson]

I have this in my report but when I go print preview I get the #size error.

=[qryRequested Course_CrosstabFY23 subreport].[Report]![Text17]

I have tried
=NZ([qryRequested Course_CrosstabFY23 subreport].[Report]![Text17],0))

and still get it. Can somone guide me in what other options I have?

Thanks

 

[CJ_London]

what is the value you see in text17?

 

[cktcPeterson]

Currency

 

[CJ_London]

Is that the word 'Currency' or you see currency type values? Reason I ask is your nz function returns a 0 value not "0" so implies it is a number, not text.

So just wondering if Text17 is a label, not a textbox

suggest upload enough of your db to illustrate the problem

 

[cktcPeterson]

Text117 is in subform and the control source I have: =Sum([PaymentAmount])
the format is set to Currency

 

[CJ_London]

is text117 in the subreport header or footer?

and perhaps try .[text117] rather than ![text117] - ! late binds so in this situation may be too late

 

[cktcPeterson]

That did not work.

I did it to be 0 if the filed is null.

Becasue I don't have anything invoiced yet, the report view shows $0, but the print view says #Error.

When I try
=Nz([qryRequested Course_CrosstabFY23 subreport].[Report]![Text17],0) I get #Size!
When I do
=[qryRequested Course_CrosstabFY23 subreport].[Report]![Text17] I get #Error!

 

[CJ_London]

you are not answering my questions - so further speculation is pointless

 

[cktcPeterson]

I figured it out. I needed to add Clng to the begining.