I’m trying to display certain fields on a report based on which company I am in. I need to use the VISIBLE function to change the property based on the company name I get from the COMPANYNAME function, correct? I can’t seem to get the syntax correct to change the visible property … any help here?
Hi Give the control on the form a name then it is CurrForm.“Control name”.VISIBLE(COMPANYNAME=‘The company Name’); That should do the trick. Paul Baxter
Unfortunately VISIBLE does not work in reports. I this case you should create different sections for each Company.