Expression Builder : MS ACCESS FORMS
 

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

Re: Expression Builder : MS ACCESS FORMS
 

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.

Re: Expression Builder : MS ACCESS FORMS
 

Its not working.Please help me with Expression builder

Re: Expression Builder : MS ACCESS FORMS
 

Just type the following in the expression builder:

=NZ([Weight_likely],"Hello")

Re: Expression Builder : MS ACCESS FORMS
 

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