Invisible field becomes visible when filtering

[MarkusArchus]

I have a form with a text box whose Visible property is
set to No. When I click on Filter by Form, this text box
appears, and it remains visible after I apply the filter.

Any idea why this would happen and how to stop it from
happening? Deleting the text box is not an option. I
tried setting the Visible Property to No in the Filter
event procedure, but that doesn't work. Setting it in the
ApplyFilter event does work, but then it's still visible
while filtering.

The text box in question is on a Tab control, if that
makes a difference.

 

[judgehopkins]

I cannot reproduce this behavior.

Please give us a step-by-step account of what you did and maybe we can figure it out.



Judge Hopkins

http://www.psc.state.mo.us/adjudication.asp

There are only two rules for success: (1) Never tell everything you know.

 

[MarkusArchus]

Step by step to produce the problem.

1. I'm using Access 2000; I don't know if it occurs in 2002.

2. Create a form based on a table in design view.

3. Place a tab control on the form.

4. From the Field List, drag down several fields and place within the tab control.

5. Change the Visible property for one of the fields to No.

6. Switch to Form View. The field for which Visible is set to No, is not visible; the other fields are. All of which is as it should be (so far).

7. Click the Filter By Form icon in the toolbar. The invisible field appears.

8. Click the Apply Filter button. The invisible field is still visible.

 

[judgehopkins]

The reason I could not reproduce the behavior you mentioned in the first post was because you left out some things and told me in the second post.

THEN I could reproduce the behavior.

In the properties where you properly set visible to no, set the display to print only.

Worked for me....

Judge Hopkins

http://www.psc.state.mo.us/adjudication.asp

There are only two rules for success: (1) Never tell everything you know.