#NAME? Error keeps coming back

[tharless]

Hello All,
I have a report that has 2 text boxes containing numbers based from a table, a third text with an if funtion, =IIF([text1]=0,"NA",[text1]/[text2]), this box is meant to be a percent of box 1 and 2. When I run the report I get the #NAME? error, I go into design view and all the control sources and names are correctly spelled, non-circular, and non-conflicting. I make any change at all to either the if formula or the name of the text box, save and problem solved, so i think. I then close the database, re-open it and there it is again, #NAME?, starting to drive me crazy, everythime i fix it, it comes back as soon as I close and re-open. ANY thoughts?



Thanks in advance

[RayMilhon]

First why are you checking the numerator for 0 instead of the denominator?

0/1 = 0
1/0 = error

[tharless]

Thanks for the response, I have it set that way because if the person in the report has no data in text one I do not want any result to appear at all, in other words I dont want it to show 0% as that would look negatively on the person. The formula works as it should, like I said whenever I change the name or re-enter the formula, the problem is after I close the db it errors again.

[RayMilhon]

Ok, what that's telling me is that the first time you open the report something is not set yet After you've opened in Design and made retyped it's ok.

Try this use the actual fieldnames instead of the textboxes.

=IIF([fieldname1]=0,"N/A",fieldname1/fieldname2)

[tharless]

Nope, it fixed it until I closed it and re-opened it, then back to the #NAME?

[RayMilhon]

Can you remove sensitive data and post the DB here?

[tharless]

Sorry, I work in the claims department of an insurance company and even with sensitive data removed I could get fired for posting it.

[RayMilhon]

Understand I work in Healthcare.

[RayMilhon]

Maybe you could use the documentation feature of access and document the report. Post the document. It'll show all of the fields and properties of the report but none of the data.

[RayMilhon]

If in doubt clear it with your boss

[tharless]

That I could do, but I'll warn you it 47 pages

[tharless]

Sorry I should have mentioned the box giving me the trouble with the formula in it is named MonthSDC%, the boxes used in the formula are named txt1, with control source of [MonthCLMTS], and txt2 with control source [MonthSDC]

[RayMilhon]

Ok, I don't see any issues. Try something for me just out of curiosity. Close the DB and open it run the report get the error go to design mode. Change nothing save the report and re-run it let me know if you get the error the second time.

[RayMilhon]

Ok did a search on the PDF file for txt1, txt2, MonthSDC, MonthCLMTS and found none of them.

[tharless]

I will have get to back at it tommorow, I'm in the eastern time zone so its after 5 and time to go, thanks again for all your help.
The text boxes are on a sub-report that may be why they didn't show up.
I will run the documentation report on the sub report tomorrow and post it.
Thanks again, have a nice rest of your day