>Hello fellow viewers,
>
>I would like to include a numeric field in a view filter.
>
>However, when I do, and then bind that view to a query-by-example form, the numeric field cannot be null. This works fine as long as the user uses the numeric value to do the lookup, but what if he doesn't?
>
>If I set the .value of the field to "", I get a data type mismatch.
>
>Has anyone done this successfully? If so, how?
If not NULLable, the empty numeric value is 0.