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.

You set the visible property for controls on forms and report, not fields in the record soruce.

You can view the property sheet for the control. Look on the other tab to get a control's name.


You would use somethind like this:

or You can use this one line of code:
TIP:
Fields are in tables
Controls are on Forms and reports.
Controls can be bound to Fields in a form/report's record source.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

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