Continuous Form - Help

  • Thread starter Thread starter Maria Joao
  • Start date Start date
M

Maria Joao

I need the form to make visible a label under certain conditions:

If IsNull(Alterações) = False Then
Label35.Visible = True
Else
Label35.Visible = False
End If

The only problem is that the label is visible in all the records that
apppear on the screen, and I want it to become visible only for the records
where the field "Alterações" is not null.

Can you help me with this?

Thanks

Maria Joao
 
Hi,


A possible solution is to use a control (not allowing tab stop on it)
for you label, and conditional formatting (forecolor = backcolor for
invisibility).


Hoping it may help,
Vanderghast, Access MVP
 
If your form is in Continuous Form mode, and your code is in the Current
event, Label35 in all records will have the same visible property as the
current record. You cannot change this. If the code is in the Open or Load
event, then the visibility will be set according to the Null state of
Alterações in the first record; again, you cannot change this.

This code works fine in the Current event for forms in Single Form mode. If
you can't show your form in that mode, then you have to explain to your
users that what they see is valid only for the particular (selected - if
you're using the Current event) record.

Otherwise, you can use the work-around suggest by Vanderghast in his reply
(but that won't work if you're usig A97 or earlier, since conditional
formatting isn't available).

HTH,

Rob
 
Back
Top