label visible

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

My question is in regards to having a label become visible
within a specific record. Currently I have 3 checkboxes
(Reset1, Reset2 and Reset3) I also have a flashing label
called lblCall, my label (lblCall)is currently set to NOT
VISIBLE. What I would like to happen is when the user
selects the final Checkbox (Reset3) on a record then I
would like the label to become visible within that
specific record only and if the user deselects the
checkbox (Reset3) then the label goes back to the NOT
VISIBLE state. Is this possible?
 
Martin,

If this form is a single view form, you can put code on both the Current
event of ther form itself, and the AfterUpdate event of Reset3, like this...
Me.lblCall.Visible = Me.Reset3

If it is a continuous view form, this is not possible. In this case,
you can use Conditional Formatting to achieve an equivalent effect. You
will need to chage lblCall from a label to a textbox, with it's Control
Source property set to ="Whatever is now the label caption" and set the
Visible property back to Yes. Then select lblCall, select Conditional
Formatting from the Format menu, use Expression Is... [Reset3]=0 and
define the format such that the forecolor is the same as the backcolor.

An alternative workaround is to set the Control Source of the lblCall
textbox to...
=IIf([Reset3]=-1,"Whatever is now the label caption","")
 
Back
Top