How to get Form for a new record with un-required Number/Percent fields that start blank?

[billyfw]

I have a table called DB_Rules, with some fields that are Numbers and Percents. They are not required fields.

I am making a LINKTOFORM call (LINKTOFORM("DB_RULES_Form","PayeeStringToMatch",[PayeeName],NewCategory,0)) on an action to create a new rule. I want the form to open with MinAmount, MaxAmount, and MatchMargin blank. And then the user can put a value if they desire. 

No matter what I do, the form appears with 0 pre-populated, and the user also cannot delete the 0 to make the field blank. Making Value_if equal TRUE also didn't have any effect. 

Any ideas?   

(I have tried initial values of "" and of Number("") but neither seemed to work).

Thanks! 

[dbaum · Accepted solution]

I think the "0" is simply a display value that appears in the form but is not actually saved to the data source when you save the form. As others have commented, this indeed is confusing in some scenarios.

Are you saying that those columns indeed end up with a 0 in the data source?

[billyfw]

Wow. You're correct. The 0s don't get saved.

Oops, I never checked that. I just started trying to figure out how to remove them. Would have saved me an hour of trial and error! 

Thanks for the fast answer! Cheers.