Show a numeric field as NULL

I have a user who requires a numeric field on a FORM / PAGE to default to blank i.e not zero can this be done and if so how.


please check whether BlankZero property is set to yes for that field

Yes if you will Change BlankZero Property to YES it will not so you as 0 on integer values instead it will keep it as blank.

I hope its reverse?

Hi Mohana,

By default if we choose any column as in Integer Data Type then it always keeps 0 value in itself and BlankZero Property is No by Default, but if we change this Property to Yes for this column then it won’t show you 0 value instead it will come as Blank until and unless some value is deliberately filled.

misunderstood your sentence with typo (show as so)