Access reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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


Marlon said:
I have created a report that prints currency fields. I want to know how to
Click to expand...
have it not print $0.00 if nothing is entered in a field.
 
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.
Click to expand...

Set the Control Source of the textbox to

NZ([fieldname])

NZ will return zero if fieldname contains a NULL.
 
Back
Top