[AccessD] no automatic round up/off

pedro at plex.nl pedro at plex.nl
Fri Jul 11 10:06:03 CDT 2008


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



More information about the AccessD mailing list