How to get rid of this?

[Lou_Reed]

In the current db contained in the attached file, when one opens up frmAttendance, one should notice that down in the lower right hand side there seems to be an inconsistency.

#Type is shown to the left of the refresh button, but it should not be there. I am not sure how to get rid of it. It simply should not be there.

Any help appreciated. Thanks in advance.

Respectfully,




Lou Reed

[alansidman]

Go to your design view for the form. You have a control that contains the following expression.

=IIf([txtTotalGvt]>0,Int([txtPresentGvt]/[txtTotalGvt]*100) & '%',"N/A")

If this expression is not needed, then delete the control while in design view.

[Lou_Reed]

It is needed. I cannot delete it. It has to stay.

Respectfully,

Lou Reed

[Lou_Reed]

I got this one. The error was an improperly identified variable.

Thanks anyway.

Respectfully,

Lou Reed