I have this database where I have created a report based on a query. The report shows an inventory item and the amount of money that has been put into it. There is ten different funds that can have money amounts assigned to it. The funds can all have a value or only one of them can have a value depending on how old the asset is. The report displays all the funds regardless of whether there is an amount assigned to it. The text boxes are set to be visible by default and have there can shrink property set to yes. The default value of the fields is set to $0.00. In the VBA code I have set an On Format event that will evaluate the value in the field. It’s a basic if statement that says if the value in the field is 0 then set the visible property to false. Each item is then totalled after all the fund information. When I run the report it hides the fields regardless of whether there is a value in the field or not. I have tried several different methods to get it to display with almost no success. The one way that did work was to put an else statement in the if statement but then it added the following field and made it visible when there was no value. I am completly befuddled as to why this is happening. Does anyone have any suggestions?
