Access 2007 - Report Field Will Not Display Cents

[lrdave36]

Hey guys,

I have an access report that will not display my dollar amounts correctly. For example, $9704.23 displays as $9704.

I went to design and the field is a text box. I set the decimal property to 2, but it changed the display to $9704.00. Why won't it show my actual cents?

The report is pulling data out of my Access table and the record field in the table does have the cents.

 

[SkipVought]

Hi,

What is the Field Data Type EXACTLY in the Table Design?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lrdave36]

I figured it out. The report was actually pulling from a master table and the field data was formatted to round to the nearest dollar. My bad. Thanks!