Access Data Types

[mattster1010]

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]

AFAIK: enter the data as text, and use conversion functions if math needs to be performed on it. .02 Stan

[CreganTur]

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