Invisible field in a report

[ybg1]

In a report on a certain condition i want the field to be invisible


and the code is :
If Me.Field1 = 1 then
Me.Field2.Visible = False
End if
But the problem is that when I type Me.Field2.
the word Visible doesn't appear on the list.

I use Access 2003.

[pbaldy]

You want the name of the textbox displaying Field2, not the name of the field. Then the visible property should be displayed. If that is the name of both, Access may be confused but you should be able to type in Visible and use it anyway.

You can also use Conditional Formatting, by setting the font color appropriately.

[ybg1]

I've changed the name of it to another name so the text box has different name than the field and it is the same.
I'm trying to do that on the Format_Detail part .

[pbaldy]

Well, like I said if you're using the name of the textbox, you can just type Visible and it should work. Sometimes the intellisense goofs up. The detail format event is the correct event, but don't forget to add an Else clause that sets Visible = True.

[ybg1]

Thanks a lot.

I've tried without a condition and found that the visible=false worked.

Than I made a condition that if the value is Null than visible=false ELSE visible=True.

Great stuff

[pbaldy]

Happy to help.