Working with Subform controls

[dweekley]

I have a subform set to continuous. Each record row has a button for opening comments specific to the record. This appears to be working fine. I would like to change the caption of the button if notes exist, otherwise no caption.

I am using the following with the event Onload on the subform.

If Len(txtESTOPSCMNTS & "") > 0 Then
btnESTOPSCMNTS.Caption = "N"
Else
btnESTOPSCMNTS.Caption = ""


End If

I am thinking that every button's caption is changing because the code is not properly identifying the correct record?

[pbaldy]

Code like that won't work. Look at Conditional Formatting on the ribbon, though you'd have to use a textbox or label rather than a button.

[dweekley]

Ha...I guess I need to stop using Access 2000

[pbaldy]

No different in later versions. Code to format record-by-record works in reports but not in forms.