Member Avatar for stan yost

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?

  • 2 Contributors
  • 2 Replies
  • 134 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by stan yost
Member Avatar for jireh

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
Member Avatar for stan yost

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.