I have a section with a repeating table and field headings inside it. One of the fields is for currency, e.g., "Dollar", "Pound", etc (via a drop-down list box). Users can choose from 1 of 2 accounts. One account uses several currencies, while the other is only in Dollars. Otherwise all the fields are the same in the 2 repeating tables. Since the Dollar-only account doesn't need the currency field ("Dollar" is the default value), I would like the user not even have to see this field and heading. How can I make this field invisible, or to make the width 0, when the user chooses the Dollar-only account?

I tried conditional formating, but it is still visible even though I disable it or hide it. Can this be done with a rule (I'm not a programmer), or if not, can it be done with code?

I did create 2 identical sections and repeating tables with the currency manually shrunk as much as possible in one of the repeating tables. I then used conditional formating to hide one or the other section and repeating table, depending on the account chosen. However, I'm not sure that this is the best method, especially since both are bound to the same data source.

By the way the data source is a SQL Server endpoint used as the web service that uses stored procedures with input parameters, e.g., the account ID is an input parameter.