how to display field value as a button caption on a continues form

[MilaK]

I'm trying to diplay [AA_change] field value as a button caption on a continues bound form. (Each record has a button).

The following code displays the same caption for all of the records on the form, which is not correct. Please suggest something. Also, please let me know if this is not possible to achieve?

Thanks

Private Sub Form_Load()

    If Nz([AA_change], "") <> "" Then
        Me.btnAA_change.Caption = [AA_change]
    Else

    End If

End Sub

 

[Galaxiom]

Use a bound textbox to simulate a button. Modify the forecolor and backcolor to the colours used for your buttons and the Raised SpecialEffect so it looks more like a button.

For click feedback, switch the SpecialEffect property to sunken and back to raised after a short delay in the Click Event. It will usually make all instance of the button move but at least it provides some feedback.

 

[MilaK]

Use a bound textbox to simulate a button. Modify the forecolor and backcolor to the colours used for your buttons and the Raised SpecialEffect so it looks more like a button.

For click feedback, switch the SpecialEffect property to sunken and back to raised after a short delay in the Click Event. It will usually make all instance of the button move but at least it provides some feedback.

I like to display a small image on a button next to text, however, this is not possible with a textbox? it looks like I'm going to have to use a texbox instead of a button. Thanks