Matthew, In forms I usually place in the OnBeforeStartEep SET NULL ' ' RETURN and in the OnCloseEeep SET NULL -0- RETURN which allows the fields in the form to be "empty"
In reports you can select any Edit or Variable and in the properties you can select Blank when zero Those 2 things help the presentation to be better. Jan -----Original Message----- From: "Matthew Burke" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 28 Mar 2008 15:03:21 -0600 Subject: [RBASE-L] - How do I make NULL truly NULL? I imagine there’s a simple way to do this but I can’t manage to figure out how. I try to use R> SET NULL ‘’ and it does nothing, NULL keeps whatever value it previously had stored, in my case that is -0- which I believe is the default. I want NULL to be void of any and all data, both visually and logically, not represented by some text I define. Matthew Burke Pioneer Bank - IT Department Computer Systems Technician 505-627-4415 This email contains PRIVILEGED AND CONFIDENTIAL information intended only for the use of the addressee(s) named above. If you are not the intended recipient of this email, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination or copying of this email is strictly prohibited. If you have received this email in error, please notify us by replying to this email and delete this email from your records. Thank you for your cooperation.
