Getting rid of ### signs

[Lorlai]

I have some large numbers (3.666667, 11.833333, etc) that appear on my tables, forms, and reports as ######. I want to be able to display only the last two decimals (3.67, 11.83, etc). When I tried to go in through the table properties and change to the details to only two decimals, lots of things in my database were then messed up and I was unable to update items due to type conversion failures.

Is there another way to do this without going through the properties window?

[gopherking]

For your Reports and Forms, you can set the number of decimal places to display via the object properties under the Format Tab. Setting the format at the field level on a report/form doesn't affect the number in other locations within the database, but you do need to make the change on each report/form in order for them all to match.

Other than that, you would want to set the format at the table level which should cascade to all reports/forms that use that field. But from your post it sounds like this wasn't working for you. At least you can change it at the form/report level.

[Lorlai]

Hi gopherking,

Thank you for your response. I tried what you suggested and changed the number of decimal places in the property sheet for each occurrence in my report. However, I am still seeing the ### and the numbers kept more than two decimal places.

Does anyone have another idea on how to make this work?

[alansidman]

you might want to try the format function in your reports/queries.

Here is a quick tutorial on formatting numbers.

http://www.techonthenet.com/access/f...ric/format.php

Alan

[Lorlai]

Hi Alan,

Thank you for your response. This is the same thing I have tried before, and by formatting the tables, I was no longer able to update data due to a data type conversion failure. My table that it is being uploaded to is a SharePoint List, which has limited flexibility in the format of numbers (at least as I've found). Is there a different way to go about this?

[alansidman]

I was not suggesting that you format the table, but to format the query in an expression. In this manner, you maintain the original integrity of the data, but it is displayed in the manner you prefer. Look at the last example in the link I shared where it shows formatting a query.

Alan

[Lorlai]

Hi Alan,

Sorry I misunderstood you; I was able to reformat the numbers using the query as you suggested.

Thank you so much for your help!