When I enter a decimal into a field by the time it gets written to a recordset it has been changed to zero if the value is less than one and it is rounded up if the value is greater than one.
Any suggestions?

Recommended Answers

All 2 Replies

please check the datatype of that field in your database and check their properties if how many decimal have set.

commented: very prompt, very helpful +3

Thanks. I feel like a dummy. The data type in Access was Number but the decimal places was set to Auto. Once I changed auto to 2 it worked.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.