Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 16 of 16 total
Thread Float is read as Integer ??
Sun, Jan 4 2009 4:36 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Noel

>Started a new barebone project but used the sam table and a simple dbgrid.
>Values in table look float!! Frown

>In my main app, dropped another table, datasource & dbgrid components and attached to same
>table, values are integers again! Frown
>In same app, did the above BUT with another table and values appeared float.
>
>I am going to hit my monitor! Smile

That doesn't seem to get through to the source code from my experience. What you actually need to do is get at least 7 stories above ground and then throw the whole computer out of the nearest window. That generally teaches it to behave Smiley

More seriously this is definitely a display problem. As Malcolm suggested it could be a DisplayFormat set for a persistent field. The other thing to look at is the component that's being used to display the table. If its not confidential post the code in the binaries so we can have a look.

Roy Lambert [Team Elevate]
Sun, Jan 4 2009 2:49 PMPermanent Link

Bill Edwards

try: FormatFloat( ',0.00', WhateverValue.AsFloat ) to display to 2 decimal places;

or check your settings: http://office.microsoft.com/en-us/access/HA103335501033.aspx
Fri, Jan 9 2009 12:52 AMPermanent Link

Noel Marshall
Bill Edwards <sdbgrump@hotmail.com> wrote:


try: FormatFloat( ',0.00', WhateverValue.AsFloat ) to display to 2 decimal places;

or check your settings: http://office.microsoft.com/en-us/access/HA103335501033.aspx

Hi Bill,
I have tried that too Smile
BUT..uploaded the app to another PC runnign XP (don't know if it's relevant) and lo and
behold.....floats became floats again!!
All is well. it's just on my PC that floats are becoming integers.
I noticed too that when trying to print from qreport's preview, pressing the print button
does NOT print anymore!!
I think I am up for a re-installation Frown((
Mon, Jan 12 2009 11:03 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Noel,

<< All is well. it's just on my PC that floats are becoming integers. >>

If that's the case, then check your regional settings in the Control Panel
to make sure that the format for floating-point numbers has not been
changed.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Jan 12 2009 12:13 PMPermanent Link

Noel Marshall
Hi Tim,

That was the first thing I did, and it has never chnged from 2 decimal places Frown

Any other ideas please???
Thanks

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Noel,

<< All is well. it's just on my PC that floats are becoming integers. >>

If that's the case, then check your regional settings in the Control Panel
to make sure that the format for floating-point numbers has not been
changed.

--
Tim Young
Elevate Software
www.elevatesoft.com
Tue, Jan 13 2009 12:33 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Noel,

<< That was the first thing I did, and it has never chnged from 2 decimal
places Frown>>

That is the only thing that would affect just your machine.  If you move the
exact same application to a different machine and it works, then the
difference must be in the OS and not in your application.

--
Tim Young
Elevate Software
www.elevatesoft.com

« Previous PagePage 2 of 2
Jump to Page:  1 2
Image