Default value on form and report after update

  • Thread starter Thread starter slagg7575
  • Start date Start date
S

slagg7575

Hi all,

I have a subform with many number feilds, like over 20 of them. What I
would like to do is have any of the fields that are left blank, no data
entered, to have the words "ND" (not done) entered automatically. I
print out a report of this data when I finish entering the some of the
fields, so I need the data "ND" for the blank fields to be on the
printed report as well. Can this be done?

Thanks!
 
Hi all,

I have a subform with many number feilds, like over 20 of them. What I
would like to do is have any of the fields that are left blank, no
data entered, to have the words "ND" (not done) entered
automatically. I print out a report of this data when I finish
entering the some of the fields, so I need the data "ND" for the
blank fields to be on the printed report as well. Can this be done?

Thanks!
Click to expand...

On the TextBox in the form and report use a format property of...

0;0;0;"ND"
 
Thanks Rick,

Will this also work if I have number fields with decimal vaules of 2.23
and 4.3 for example? The other blank fields will of course be "ND" if
left blank.
Thanks!

Rick Brandt wrote:
 
Thanks Rick,

Will this also work if I have number fields with decimal vaules of
2.23 and 4.3 for example? The other blank fields will of course be
"ND" if left blank.
Thanks!
Click to expand...

The zeros in my example were just that, examples. Each section represents
respectively...

How to format Positive values
How to format Negativevalues
How to format Zero values
How to format Null values

You have to put something in each section or that type will not display at
all. Change the three sections to whatever works best with your data. For
example you could try...

#0.00;#0.00;#0.00;"ND"
 
Back
Top