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.
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.