[AccessD] no automatic round up/off

Pedro Janssen pedro at plex.nl
Sat Jul 12 07:21:27 CDT 2008


Hello Gustav,

nothing worked on the form that i was using.
So i made a new form with the same fields and it worked fine.

Can a form also be corrupt?

Pedro


----- Original Message ----- 
From: "Gustav Brock" <Gustav at cactus.dk>
To: <accessd at databaseadvisors.com>
Sent: Friday, July 11, 2008 12:18 PM
Subject: Re: [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
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list