How to use multiple buttons to populate text box with text string in MS Access Form?

Question

I am building a form in MS Access and I am trying to use buttons to populate a sequence of text into a text box. The idea is that each button will add onto the information to the string sequence. So far I have only been able to populate the text box with the info of a single button, which gets replaced when another button is clicked.

I used the following for each button:

Private Sub btnBP_Click() 
    txtSequence.SetFocus 
    txtSequence.Text = "BP"

How can I make subsequent button clicks add onto the information and not replace it?

Gustav · Accepted Answer · 2021-08-03 17:31:09Z

3

Don't replace the text, append the new text:

Private Sub btnBP_Click()

    Me!txtSequence.Value = Me!txtSequence.Value & "BP"

End Sub

answered Aug 3, 2021 at 17:31

Gustav

56.4k7 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use multiple buttons to populate text box with text string in MS Access Form?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related