Hi,

Please help me with Expression builder for my FOrm.
Weight_likely - back end DB Column
I want an expression, where if Weight_likely is blank then in form 0 should be populated or if Weight_likely has a value then the value itself should be populated.

=IIf([Weight_likely]="",0,[Weight_likely])

Please help me on this.

Regards,
Jagadeep Reddy

You can use the NZ function:

nz([Weight_Likely],0)

The nz function will function will return [Weight_Likely] if it is not null. If it is null, it will return 0.

Its not working.Please help me with Expression builder

Just type the following in the expression builder:

=NZ([Weight_likely],"Hello")

If you can't get timothy's suggestion to work, type null rather then "" in your condition.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.