Access reports

[Marlon]

I have created a report that prints currency fields. I want to know how to have it not print $0.00 if nothing is entered in a field.

 

[fredg]

I have created a report that prints currency fields. I want to know how to have it not print $0.00 if nothing is entered in a field.

If nothing is entered it is Null.
What do you wish to print if the value is 0?
You can set the Format Property of the control in this order..
PositiveValue;NegativeValue;Zero;Null
i.e.
#.##.00;-#,##.00;$0.00;""

If you do not wish to show a Zero if the field value is Zero (which is
not the same as Null):
#.##.00;=#,##.00;"";""

If you also wish the $ sign, place it in front of each section, i.e.
$#,##0.00;-$#,##0.00;"";""

If you do not wish to have the values comma delimited by thousands, or
set to 2 decimals, use:
#;-#;"";""

Look up in Access Help...
Format Property + Number and Currency Datatype

 

[PC Datasheet]

Open your table that contains the field in design view and selet that field. Go
to the bottom of the screen and dlete "0" as the default value.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

I have created a report that prints currency fields. I want to know how to

have it not print $0.00 if nothing is entered in a field.

 

[John Vinson]

I have created a report that prints currency fields. I want to know how to have it not print $0.00 if nothing is entered in a field.

Set the Control Source of the textbox to

NZ([fieldname])

NZ will return zero if fieldname contains a NULL.