field not printing dilemma

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
 
F

Fons Ponsioen

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
 
F

fredg

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
 
C

Chrissy

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
 
F

Fons Ponsioen

If you wish you can email me an mdb with some sample data
and query/report.
fonsponsio at the ISP sbcglobal.net
Fons
 
C

Chrissy

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...
 
F

Fons Ponsioen

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
 
Top