field visible-not visible

  • Thread starter Thread starter Junior
  • Start date Start date
J

Junior

report Header section contains
two bound controls [txtPos] and [txtArea] with corresponding labels lblPos
and lblArea
if the two txtboxes contain identical data
i.e. IF txtPos=txtArea Then I want lblArea and txtArea to be invisible
otherwise all should be visible

Plse help with proper code and location?
 
On the On format section of the report header write the code

Me.txtArea.Visible = Not (Me.txtPos=Me.txtArea )

About the lable, it should be set to visble false if you set the text box to
false, but you need to attach the lable to the text box, if it's not already
is
 
Back
Top