Setting up form to allow decimals

cnut1

Registered User.
Local time
Today, 17:02
Joined
Aug 11, 2005
Messages
25
I need to have a field on my form to accept the user keying in the number in this fashion: 200200.1234 but as I currently have it set it accepts only the 200200 portion of this part number. I am a beginner so I am sure this is an easy question for some of the pros out there.

As a footnote the table design has the bin no. as data type - text and I added an input mask of 000000.0000;0; the field on the form is a combo box. Maybe that will make a clear picture for you.

Thanks in advance for your assistance.
 
Last edited:
Rich
I changed the data type from integer to double on the table, however when entering the bin no. in the appropriate field on the form it still only takes the first 6 digits and nothing after the decimal. Also I found out I may run into bin no.'s that do not have anything after the decimal and some that may include letters in the alphabet as well as numbers.
 
Rich
I changed the data type from integer to double on the table, however when entering the bin no. in the appropriate field on the form it still only takes the first 6 digits and nothing after the decimal. Also I found out I may run into bin no.'s that do not have anything after the decimal and some that may include letters in the alphabet as well as numbers.
 
Then you have to change it to text or use two separate fields, did you set the decimal places property on the property sheet?
 
I did change the bin no. on the table to text. But then it would drop some of the zeros. i.e. correct number 200200.0100 now shows as 200200.01 thus dropping the last two zeros. As for the properties on the datasheet I am not sure I did set them correctly, I did not see an area to set your decimal places. I did go into the properties of the bin no. field and the decimal places are set to "auto", should this be changed?
 

Users who are viewing this thread

Back
Top Bottom