Hi,
I'm stuck trying to set the numerical format of a text box on a report. All of the documentation that I can find isn't working for me, can someone steer me in the right direction?
1. The numerical format was set in the properties tab for that box, I set it to "General Number" and Decimal Places "0"
2. I set the control source for the box programatically based on parameters when the report is launched:
Code:
Reports!OpenRecordRpt!daysElapsedBox.ControlSource = "COM_INSTATE"
3. The numerical format is being overwritten by the contents of the control source, which are floats. I only want to see the integer of those floats, so I want to set it back to zero decimal places. This is what I tried:
Code:
Reports!OpenRecordRpt!daysElapsedBox.format = (0, "Fixed")
This is causing a syntax error, what am I doing wrong here?
Thanks in advance,
-Paul