Hi access users,
Having a report that on the footer section displays the total of a field, how do i have the total
displayed on the immediate window ? The reason is to search why the total is displayed roughly with
no decimal digits. For instance 430 in place of 427,5.
Thanks for ur care,
P

Hi Penta,

I don't know if you can - just due to the nature of the report.

Try design view of the report and in that particular textbox, look at the properties and see what the Decimal Places property is set to.

Hope that helps,

Mike

Mike
EchoVue.com

Thanks Mike,
That has come to my mind too but it was not the solution. Reports are difficult
to update sometimes and probably it happened this time. I'll have to review all the code but i thought maybe someone would point a way to resolve
the problem easily.
rgds P

Hi everyboby,
It's better late than never. I've done a very complicate way to find a very
simple error. I've used code to print the name of the controls of the report
to the Immediate window.How?
      Sub ListControlsOnOpenReports()
       Dim rpt1 As Report, ctl1 As Control

'Enumerate all open reports
        For Each rpt1 In Reports
        Debug.Print rpt1.Name

'Enumerate each control on a specific open report
    For Each ctl1 In rpt1.Controls
        Debug.Print " " & ctl1.Name & ", " & _
            IIf(ctl1.ControlType = acLabel, "label", "not label")
    Next ctl1
Next rpt1

End Sub


 Then i've coded the preview report code to print
the value of the textbox that was having a wrong sum to the IW. How ?
       Debug.Print Reports("MyReport").MyTextBox
When i checked the value i've saw that the textbox having the wrong value
wasnt the one i've been working on. Yes, it was a rough mistake and i'm sorry
for having been wasting ur time.
Tks P