unable to format numbers properly

[Bill Moore]

I have 6 text boxes in a report detail section. I want them formatted all the same way (I really don't even care which way), just the number with no decimal places as an example.

I selected all 6 text boxes, selected properties, format, and changed them to fixed, with 0 decimal places as one example. When I print the report, I have numbers all over the place; some with 2 decimal places, some with 1, some with 0, and others with a number of decimal places so large, I can't even see the integer part of the number.

In the original table from which the data is derived, all numbers look fine; just the number with 2 decimal places.

Just for information, the report is the last step in a query process with the eventual data source being a union query. Also, I've done many other reports the same way with no problems.

Any ideas?

Thx.

 

[uncle-lai]

I had the same problem before, especially with summed fields in union queries. It is said to be a floating point problem with Access. I finally used used a different name for the text box in the report and set the control source to a Round() function:

eg: Control Source of txtAmount as
= Round(Amount, 0)

Wish this work for you too.

Peter