In Table Design View, for a Single Data Type Field, try setting the Number of Decimal Places to 4, and the Format of the Field to Standard.

This should have

**Format **as

**Fixed**, not Standard.

But this is cosmetic. A numeric field, whether in a table or on a form, contains a value. A Single would have 2 components, an Exponent a Significand. In the case of a value of 5, the exponent is 0 and the significand is 5. Adding a decimal point and any number of 0s does not make this representation more or less accurate. 5 = 5.0000000000000000

If the problem is displaying the numbers, this is a Format issue. If the problem is accuracy in calculations, then the issue is more complex. All the Number or Currency data types store data as binary numbers, and therefore cannot represent the fractional part of the value accurately. The number of bits devoted to the fractional part is enough so that this is not normally a problem, but it could be.

The numbers are stored in a temporary table. Just storing them cannot matter how they are formatted. How are they used? What is the reason for needing 'place-holding' trailing zeros?