Strange formatting in textbox on report, sporadic and unwelcome

  • Thread starter Thread starter Yblitzka
  • Start date Start date
Y

Yblitzka

We have a report in our database app (Access 2k format, using Access 2002 or
2003, windows XP, SQL backend) that has a currency field in a group footer of
a subreport.

Occasionally this currencty field will HICCUP and we'll get a very strange
formatting error. It doesn't happen with every group when it does this, and
for how often it happens, I've never found a rhyme or reason for it (like
it's that footer with that group and that number, etc.)

This currency field, instead of printing right justified, like this:
edge of text box| $1,630.00|edge of text box


Will print in some variant of this:
edge of text box|$1, 630.00|edge of text box

Sometimes the thousands place holder and the comma are the only characters
pulled over, and sometimes it will be the entire dollar total plus the
decimal point, and the cents remain right justified.

There are no special conditional formats in place on this text box. It is a
calculated value, and the formatting is actually set to CURRENCY and Right
Justified. I do not recall ever seeing this in the Preview, so I accept that
it may be related to our pdf printer, but I'd like to know if someone has
seen this before.

Does anyone have any suggestions or thoughts? perhaps someone has seen this
occur? I can't tell our sales reps to just live with it - this looks bad when
it goes to our customers, however rarely.

TIA!
blitz
 
Never mind - it appears to be a driver problem with a specific type of
Brother printer we are using.


Thanks anyway!

blitz
 
Back
Top