General

Re: Conditional formatting issue

ErnestoM — Fri, 01 Oct 2010 17:21:27 GMT

Thanks for the screenshot. The condition looks correct.

Where is this condition set? You'll need to have the same condition on both the fields.

I would also look at the fields' data types to make sure they match exactly.

Re: Conditional formatting issue

tweeter77 — Fri, 01 Oct 2010 16:26:17 GMT

Thanks for responding.

I have attached a screenshot of the Options in the Conditional Formatting window of the section I want to hide. As you can see, I have told it that when Grand Total and Neta_Total are equal to hide the section. When the form is loaded, it is hidden as both of those fields are $0.00. However, when numbers are entered and a calculation occurs, the section shows up regardless of what is entered. Even if both Grand_Total and Neta_Total equal $5.00, it still shows up.

Aaron

Re: Conditional formatting issue

ErnestoM — Thu, 30 Sep 2010 13:33:28 GMT

Can you attach a screenshot of the conditional formatting window using the Options tab when you reply? Thanks

Conditional formatting issue

tweeter77 — Wed, 29 Sep 2010 18:15:48 GMT

Hello,

I have a repeating table with a specific currency formatted column. I am pulling the sum total of this column in a text box (textbox1) using "sum(column)" for default value of textbox1. I am trying to hide a section based on whether this summed text box (textbox1) equals another textbox (textbox2). So if textbox1 equals textbox2 hide this section. If textbox1 does not equal textbox2 show this section. I put this logic into the conditional formatting of the section and it is not working. When I first open the form, it is hidden (which is good). But when I enter any dollar amount in the column the section shows up. Even if I enter the a dollar amount or series of dollar amounts that cause textbox1 to equal textbox2, the section stays shown. I can clearly see that they are equal and are both textboxes formatted the same (decimal, currency, 2 decimal places). Anyone have any idea what is wrong?

Thanks,
Aaron