The Setup: I have a simple report based on a query. The detail section is composed of 12 text boxes, side-by-side, all tied to one of the query fields.
Every text box has the following formatting:
Format: Currency
Can Grow: No
Can Shrink: No
Text Align: Right (same prob if no alignment)
The boxes do not overlap, and there's plenty of space in them for the data in the chosen font and size.
When previewed, the report looks perfect.
The Problem: When printed, some of the text boxes shift over to their lefts, butting up against the text box to the left of them. In fact, they actually shift further than that, so their text is butting up against the text to their left (even crossing over the space where a parenthesis would be if the left number was negative).
This almost only happens if the value of the field is $0.00, but there are tons of times when a $0.00 stays right where it's supposed to be. Most of the time, by far.
I can't detect a pattern as to what might be goofy with the rows it happens on -- there can be one above it or below it that is effectively identical and its numbers stay still.
Any ideas?
Every text box has the following formatting:
Format: Currency
Can Grow: No
Can Shrink: No
Text Align: Right (same prob if no alignment)
The boxes do not overlap, and there's plenty of space in them for the data in the chosen font and size.
When previewed, the report looks perfect.
The Problem: When printed, some of the text boxes shift over to their lefts, butting up against the text box to the left of them. In fact, they actually shift further than that, so their text is butting up against the text to their left (even crossing over the space where a parenthesis would be if the left number was negative).
This almost only happens if the value of the field is $0.00, but there are tons of times when a $0.00 stays right where it's supposed to be. Most of the time, by far.
I can't detect a pattern as to what might be goofy with the rows it happens on -- there can be one above it or below it that is effectively identical and its numbers stay still.
Any ideas?
