View Full Version : Access Data Types
mattster1010
08-07-2008, 01:50 AM
I have four fields in a table that have a data type as 'Number', and field size as 'Double'. When a user enters a value, for example 9.10 the ending zero is chopped off and the value 9.1 is held in the database. Does anyone know how I get get the database to keep the zero on the end?
Cheers,
Matt
stanl
08-07-2008, 04:09 AM
AFAIK: enter the data as text, and use conversion functions if math needs to be performed on it. .02 Stan
CreganTur
08-07-2008, 05:16 AM
I kind of agree with Stan- sometimes evaluating numbers as text makes life extremely easy when you have to have specific formatting for your numbers... but for your specific problem, have you changed the Decimal property for your fields from Auto to 2? This may fix your issue.
HTH:thumb
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.