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?
stan yost
0
Light Poster
Recommended Answers
Jump to Postplease check the datatype of that field in your database and check their properties if how many decimal have set.
All 2 Replies
jireh
3
Posting Whiz
please check the datatype of that field in your database and check their properties if how many decimal have set.
stan yost
commented:
very prompt, very helpful
+3
stan yost
0
Light Poster
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, networking, learning, and sharing knowledge.