MS Access 2000 Form/Report Print Help

[neilch]

Thanks dhookom!
I tried doing a report but keep having the same problem!
Using the same code: ( tried it on On Open, On Page and on Activate for reports and On Current, On Open, After Update, etc)...
If TotalSavings > 0# Then
Me!Label654.Visible = True
Me!TotalSavings.Visible = True
Else:
Me!Label654.Visible = False
Me!TotalSavings.Visible = False
End If
Seems the code is pretty straight forward i.e. if TotalSavings > 0 then Print the label and the amount and if not Don't Print.
Appreciate you hanging in there with me! I need to get these out soon!
Thanks for your help...

 

[JoeAtWork]

I see a couple syntax errors in your code. Take out the red highlighted characters:

If TotalSavings > 0[COLOR=red]#[/color] Then
Me!Label654.Visible = True
Me!TotalSavings.Visible = True
Else[COLOR=red]:[/color]
Me!Label654.Visible = False
Me!TotalSavings.Visible = False
End If

For a form the proper place to put this would be On Current.

Have you placed a breakpoint in the first line of code to confirm that TotalSavings is indeed greater than zero?

 

[neilch]

Hi Joeatwork,
Thanks for the quick help.
I took of the code marked in red and placed it on current in the form...the form displays correctly on screen but when printing it does not print either the zero value or if > 0. Any other help you can offer would help tremendously!
Display When = Always and Visible = Yes.
Thanks,
NeilCh

 

[neilch]

Hi JoeAtWork,
Another thing I forgot to mention is that each record is a separate form and some of the values in TotalSavings are zero and others greater than zero therefore I only want it to print the label and text box value on the forms where TotalSavings > 0 and the others should not print the label or textbox. My Control Source for the textbox is =[TotalSavings]*.01...Thanks again
NeilCh