change label for current record only

[buratti]

I have a form with continuous forms view (actualy a subform of a different form) with only 3 fields: Charge type, Amount and Date.

What I need to do is change the caption of the date label to something different depending on the value of the charge type field. I figured that part out pretty easilly, but being a continuous form view, it changes the caption for all the records open in the form. Is there any way to just change the caption for the current record ONLY?

my current code is:
Private Sub Charge_type_AfterUpdate()

If Me![Charge type] = 104 Then
Me.DateLabel.Caption = "Start Date"
Else
Me.DateLabel.Caption = "Paid Through Date"

End If
End Sub

Thanks for any suggestions, or even let me know of it is just not possible too.

 

[pbaldy]

I would use Conditional Formatting. I don't think you can format a label, but you could use a textbox to achieve the same effect.

 

[buratti]

ah... good thought. I'd never of thought to use a text box instead. I 've not worked much with conditional formatting, but I agree and don't think you can format a label.