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

[RuralGuy]

Have you tried to use the IsError() function and IIF?

[keiath]

Sorry a bit a novice how would i use that in this case?

[keiath]

This has been resolved using a standard module and NZ