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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subreport label stays visible 4
Visible Property with Vista and Access 2007 1
Shrink when not visible (not when null) 2
Visible Property 3
Visible fields on a report only when printed 2
Group Header Visible Toggles 2
Running Sum Changes when not visible 2
only visible if... 4

Back
Top