Error return

[Keiath]

Hi Guys

I have this

=[Invoices Group A Totals subform2].[Form]![Text13]

Which works fine, however if there is no data it comes up with an error in the txtbox where i would prefer it was just blank how can I do this?

Thanks

 

[pbaldy]

I use

http://access.mvps.org/access/forms/frm0022.htm

 

[Keiath]

Okay bit of a novice here how do i apply this to the argument i have above

 

[pbaldy]

Copy the function into a standard module and wrap your subform reference in nnz().

 

[Keiath]

Sorry sounding like a real noob now, into a standard module?

 

[Keiath]

I have enclosed a strip out version on my database if you open the Main Site Table, form you can see the problem i am having

 

[Keiath]

Hi After fiddling about a bit i finally work it out and works fine and returns 0 instead on an error message.

Thank you for your help

 

[pbaldy]

Sorry, I was in a meeting. Glad you got it sorted out.

 

[gemma-the-husky]

nz is a useful function

it defines how to display the result if the "answer" is NULL. note that null is not the same as an empty string, which WILL return a genuine blank.

=nz([Invoices Group A Totals subform2].[Form]![Text13],"No Data")

 

[pbaldy]

This was resolved yesterday Dave, and Nz() doesn't work in this situation anyway.

 

[gemma-the-husky]

OK. I hadn't read all the links, and thought nz was a different approach. I see the problem now.