record with a null field doesn't print unless a $0.00 or some amou

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

Guest

I have a field on a form in which a reward amount is to be filled in. When
creating the record for the first time the record won't print on a report
when I look at record summary report. If I go back to the record and enter
either a 0 or a number, I can then see the record on the report. The field is
formatted as currency. Any help appreciated.
 
Then you must have something in your report that tells it to exclude items
where the value is null. The query upon which that report is based must
exclude records with null values in that field.

I'm curious as to why you posted this in a Fomrs newsgroup. It makes me
wonder if you are simply printing the form, or if you atruly have a separate
report.

If you do indeed have a report, check out the query.

Post back more details if that is not the issue.

Rick B
 
yes, it is a separate report problem. I thought it was a problem with the
form I was using. I'll check out the query.
 
Did you save the Record on the Form *before* opening the Report?

The Report only looks at the data in the Table so if the CurrentRecord on
the Form is a new Record (i.e. not yet saved in the Table), the Report won't
be able to pick it up.
 
Back
Top