You have entered expression that has no value

[rafal444]

I am getting this error. How to test for it?

I have tried for IsNUll(Value), is error(value) isempty(Value)

All returns False! How to check for this error???

 

[TheAceMan1]

How are ya rafal444 . . .

Whats the source of [purple]Value[/purple]?

Perhaps [blue]Me!TextboxName[/blue].Value

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

 

[rafal444]

Value is a calculated field on the report. =NullToZero([my query field])

 

[TheAceMan1]

rafal444 . . .

Can't say unless you post the function [blue]NullToZero[/blue]!

See Ya! . . . . . .

 

[JoeAtWork]

The name of the function suggests to me that the following can be used instead:

=nz([my query field],0)