Access truncating zeros! Help?!

[bdowne01]

Ok, this is probably a really simple question for most... but it's driving me nuts!<br><br>I need Access 2000 to treat a number field as straight text, so it doesn't drop zeros or round up or down numbers.&nbsp;&nbsp;For example, if I currently enter in &quot;160.55&quot;, it will pull in to my webpage as &quot;160.5&quot;, or if I fool with the settings at all it'll round up to &quot;161&quot;.&nbsp;&nbsp;&nbsp;I've tried just about everthing in the table design that I can think of.<br><br>I'm using this table as a pricing matrix, and I'm formatting the number (i.e. putting in the '$') in the webpage code.&nbsp;&nbsp;All I want Access to do is to store the number and spit it out as just as it's entered in--with zeros on the end!&nbsp;&nbsp;I don't need it to do any formatting. Any help is appreciated!<br><br>thanks,<br>Brian

 

[kanemra]

It may sound stupid, but I have to ask this to make sure. Have you tried using a &quot;text&quot; field. If all you want&nbsp;&nbsp;is storing the numbers as they are you don't need a &quot;number&quot; field.

 

[bdowne01]

Yea, I did try that... and it didn't work.&nbsp;&nbsp;But I just tried it again to be sure, and it did!&nbsp;&nbsp;I don't know what you did, but it worked from afar!