Hello,
Can someone please tell me how to enter a decimal number into a text box, without the system rounding the number off?
I have a text box, in a form that is based on a table column. It's formatted for number entry.
I simply want to enter a number with three decimal places. I've tried everything I can think of, but everytime I tab after entering the number, the system rounds the number up or down and I need to have it remain exactly how it's entered.
I know it's probably something very simple, but please bare with me, I'm new to Access.
Thanks

Hello,
Can someone please tell me how to enter a decimal number into a text box, without the system rounding the number off?
I have a text box, in a form that is based on a table column. It's formatted for number entry.
I simply want to enter a number with three decimal places. I've tried everything I can think of, but everytime I tab after entering the number, the system rounds the number up or down and I need to have it remain exactly how it's entered.
I know it's probably something very simple, but please bare with me, I'm new to Access.
Thanks

In Design Mode, if you view the Properties Sheet for the Text Box, there are two properties (Format and Decimal Places) that should give you what you are looking for.

Thanks a lot for your help.
While waiting for a reply I was messing around with it and found out what the problem was. Like I figured it was something simple.
I had the format and decimal places set correctly, but it was still rounding the number. The key was the "Scale" setting, which was set to 0 and not allowing it to save a number with anything to the right of the decimal place. Once set, it works fine.
You all have been great ... I'll be back.