Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.
keep trailing zeros/accept number as entered
Hi,
I'm new to Access, but have not been able to find this answer anywhere. In a data entry form, I want to be able to have the user enter any number and have Access accept the number as entered to the table. Essentially, the problem is the trailing zeros are deleted. I have attempted to enter ###,###.#### in the format property of the table. Also, I can not set the default decimal places as this will vary for each number and I will need to manipulate the numbers later, so text is not an option.
Example:
0.3090 now changes to 0.309 or .309 with formating
1259.0 now changes to 1259 or 1,259 with formating
I want all numbers to appear as entered.
Thanks!
I'm new to Access, but have not been able to find this answer anywhere. In a data entry form, I want to be able to have the user enter any number and have Access accept the number as entered to the table. Essentially, the problem is the trailing zeros are deleted. I have attempted to enter ###,###.#### in the format property of the table. Also, I can not set the default decimal places as this will vary for each number and I will need to manipulate the numbers later, so text is not an option.
Example:
0.3090 now changes to 0.309 or .309 with formating
1259.0 now changes to 1259 or 1,259 with formating
I want all numbers to appear as entered.
Thanks!
Who is Participating?
Access has its own ideas about formatting numbers, and it doesn't particularly care what the user wants. It uses any formatting you provide as more of a 'suggestion' than a rule, in my experience.
One work around is to have the field entered as a string...it will keep the formatting exactly as the user enters it. The downside is you will have to account for that conversion EVERYWHERE, and it adds to the complexity of the database. And even then, once you manipulate the numbers, Access will still have control over the format of the final result.
One work around is to have the field entered as a string...it will keep the formatting exactly as the user enters it. The downside is you will have to account for that conversion EVERYWHERE, and it adds to the complexity of the database. And even then, once you manipulate the numbers, Access will still have control over the format of the final result.
I need to keep the significant figures, entering in the input mask defeats that purpose. If there was an easy way to deal with the text for manipulations that would work, but converting to number from text string is even more of a mess than losing the trailing zeros.
you could save the number entered by your users as a text in one field and as a number in a different field. That way, for display purposes you could use the text field and for calculation purposes you could use the number field. If that doesn't work for you then it looks like you're up against a brick wall here friend.
Sorry, for not responding for so long! I was incapacitated by the flu and it's always a pain to catch back up. The reasoning for the formatting differences is that we are entering previously published biological data and everyone has their own way of doing things. Also the number of significant figures gives one an idea about the accuracy of the measurements. I really appreciate all of the help! I just thought I was being stupid for not figuring out how to accept trailing zeros in the number fields.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
Why would you want each user to determine their own number format, anyways? Creating a reporting system that does not use a standardized format is asking for trouble...