<div>
Me.CommandButtonName.Capti<wbr />on
</div>


<div>
buttonText = YOUR_FORM_NAME.YOUR_BUTTON<wbr />_NAME.Capt<wbr />ion
</div>


buttonText = YOUR_FORM_NAME.YOUR_BUTTON_NAME.Caption

<div>
Thank You.<br />
I was looking for a generic piece of code that would work regardless of the command button clicked and Me.ActiveControl.caption is what I needed.
</div>


Thank You.
I was looking for a generic piece of code that would work regardless of the command button clicked and Me.ActiveControl.caption is what I needed.

<div>
Another good one along those lines is<br />
<br />
Me.previouscontrol<br />
<br />
Good for command button code for determining the textbox etc the user was entering data in immediately before clicking the button.
</div>


Another good one along those lines is

Me.previouscontrol

Good for command button code for determining the textbox etc the user was entering data in immediately before clicking the button.

<div>
<div class="content wysiwyg-content">
When a user clicks a command button on a form in MS Access I would like to write the Form Name, command button caption, username, date and time to a file using vba. &nbsp;I know how to capture everything except for the Command Button Caption. &nbsp;How would I do that?
</div>
</div>


When a user clicks a command button on a form in MS Access I would like to write the Form Name, command button caption, username, date and time to a file using vba.  I know how to capture everything except for the Command Button Caption.  How would I do that?

Determine the caption of a command button

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.