[AccessD] no automatic round up/off

"Can a form also be corrupt?"

Pedro,

Even in my limited experience I have had several forms go corrupt.  It is hard to diagnose at first, but often just replacing the form with a backup (or new version) will resolve the issue - it is certainly worth a try and can save you (well me at least) hours of annoyance.

regards
Darryl

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Pedro Janssen
Sent: Saturday, 12 July 2008 10:21 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] no automatic round up/off


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
>

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses.  No warranty is made that this material is free from computer virus or any other defect or error.  Any loss/damage incurred by using this material is not the sender's responsibility.  The sender's entire liability will be limited to resupplying the material.