[AccessD] no automatic round up/off

Hi Pedro

A Single will not round to an integer.
Sounds like you need to remove or adjust the format of the fields (TextBoxes) of the form. Just a switch to Currency will not do it.

/gustav

>>> pedro at plex.nl 11-07-2008 12:01 >>>
Hello Gustav,

i made a typing error, i meant single.
So it still is best to use currency? Or is there another method that there is no automatic round up/of?

Pedro

In antwoord op:

> From: "Gustav Brock" <Gustav at cactus.dk>
> To: <accessd at databaseadvisors.com>
> Date: Fri, 11 Jul 2008 11:28:19 +0200
> Subject: Re: [AccessD] no automatic round up/off
> 
> 
> Hi Pedro
> 
> Data type Integer and Long and Byte have per definition no decimals.
> If four decimals is fine, use Currency for the field. Else Single or Double. Avoid Decimal as this is known to be buggy.
> 
> /gustav
> 
> >>> pedro at plex.nl 11-07-2008 10:06 >>>
> Dear List,
> 
> i have a form with a recordsource to a query, which is related to a table, in a access 2003 database (and filerange of access 2000).
> Teh table has numeric fields with Integer field length, 1 decimal place and a notation that is set to: #,#
> Also the fields in the query and form are set to 1 decimal place and notation #,#
> 
> each time a place a value in the form like 5,4 it is round off to 5,0. But i want the original value 5,4 as data. No rouding up or off.
> 
> How can i do this?
> 
> Thanks
> 
> Pedro