General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>Hi,
>>>>Can a numeric field filled with zero be made empty programatically? if yes, how?
>>>>
>>>>Tamas
>>>
>>>Check BLANK in HELP.
>>>BTW numeric field with zero in it is EMPTY() :-)
>>
>>I'd like the field not to show any 'character' in it(not even a zero). For example when you create a table with a numeric field, the field is completely blank. But after you fill it with a number, you cannot make it empty again. You only make it show a zero.
>>My question referred to how you can make it completely blank again as when it was originally created.
>
>As I said check BLANK command in HELP.
>Keep in mind that BLANK didn't work for INTEGER field type.
>Also if you don't want to show zeroes, you could put [Z] in the format property of your textbox class when it is bounded to Numeric value. That is only a matter of representation.
I just thought there's any easy way to do that.
Thanks a lot anyway.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only