From: Matt Foster Subject: Re: Displaying and editing a number to n significant figures in Forms Date: 2000/05/05 Message-ID: <3912D443.B513B554@yahoo.co.uk>#1/1 Content-Transfer-Encoding: 7bit References: <8emiuj$s0d$1@nnrp1.deja.com> X-Accept-Language: en Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@scotsman.ed.ac.uk X-Trace: scotsman.ed.ac.uk 957535408 20758 129.215.65.16 (5 May 2000 14:03:28 GMT) Organization: Edinburgh University Mime-Version: 1.0 NNTP-Posting-Date: 5 May 2000 14:03:28 GMT Newsgroups: comp.databases.oracle.tools Clint Redwood wrote: > > Does anyone have any good ideas as to how I can show number data in > forms text items to n significant figures. > > The only way I can think of doing it is to programmatically change the > format mask for each record displayed, but that won't work for multi- > record blocks, which I need. Also, it won't be possible to enter any > old number into the field since the format mask will ensure it is in > the format for whatever data was previously displayed. > > Any suggestions would be very welcome. > > Thanks, > > Clint Redwood. > > Sent via Deja.com http://www.deja.com/ > Before you buy. What about having a number field format (n,n-1) and another number column to hold the power of ten applicible? e.g if you want to hold 25489 to 2 sig figs, number1 holds 2.5 and number2 holds 4 Just a thought. Matt