field not printing dilemma

  • Thread starter Thread starter Chrissy
  • Start date Start date
C

Chrissy

HI,

My report has a field that prints the field only if the
number is positive. I have a negative number and it does
not show...however, it is included in the sum function.

The number exists in the query of this report.

I cannot find any reason that it should not print
negative numbers, while it prints the positive ones.

Any help?

Thanks,
Chrissy
 
Anyt change that the texbox allignment may affect this.
also try changing the font or the number properties such
as color, or format.
Hope this helps.
Fons
 
HI,

My report has a field that prints the field only if the
number is positive. I have a negative number and it does
not show...however, it is included in the sum function.

The number exists in the query of this report.

I cannot find any reason that it should not print
negative numbers, while it prints the positive ones.

Any help?

Thanks,
Chrissy
Click to expand...

I would first check the Format property of the control.
If the format is something like this:
#;
Change it to
#;-#
and negative values will show.
See Access Help on
Format Property + Number and Currency Datatype
 
I've tried all suggestions, but the problem remains.

Its formatted standard, 2 places, both report and table.
Please note that the sum field does in fact display the
negative. There is no apparent difference in the line-
item field and the summary field.

I don't know what else to do.
Chrissy
 
If you wish you can email me an mdb with some sample data
and query/report.
fonsponsio at the ISP sbcglobal.net
Fons
 
Sent you a very small sample. Thanks. (Natlie35)

-----Original Message-----
If you wish you can email me an mdb with some sample data
and query/report.
fonsponsio at the ISP sbcglobal.net
Fons
.
Click to expand...
 
after looking at the report, I found that conditional
formatting was applied to this textbox setting the fore
color to white when the value was less than zero.
Hope this helps.
Fons
 
Back
Top