Where to place code to hide control

[AndySuk]

Hi

I have one report which prints invoices and is based on a query. The base currency is GBP in which case the totals are in GBP. However sometimes a customer is invoiced in US$ and, in these cases, I need to show a conversion of the totals to GBP.

When there is an exchange rate then the conversion is done. Where there is no exchange rate then the text boxes holding the converted totals are blank and so do not show.

The problem that I am having is where to write the code that makes visible the lines above and below the converted total. Where there is no exchange rate then they should be set to visible=false and this is done when the report is designed. However when there IS an exchange rate then I need to switch the visibility to True and it's this bit of code that I'm not sure where to place.

Any help would be appreciated

Thanks

Andy

 

[vbaInet]

You write the code on the Format event of the Detail section. You mentioned that when there is no exchange rate there wouldn't be a value? Is there a need to hide the control if it doesn't contain data?