IDG Answers is a community of experts who are passionate about technology. Ask a question or answer one below.
Open table in design view and click the field that you are having issues with. Click the Field Size box on the General tab, then click the down arrow at the end of the box to choose Decimal on the resulting drop down menu. Save the table, and it should no longer automatically round.