A family of Microsoft relational database management systems designed for ease of use.
Thank you for the update.
I did some further testing on my side and managed to reproduce the behavior you described. I found something quite interesting that might clarify why it works sometimes and fails others.
As you can see from the image I shared earlier, my initial input text box was quite wide. When the text box is large enough to show most of the content, the "click label to select all" behavior works fine. However, I tested the case where the input text box is smaller (shorter) or when the content has multiple blank lines/gaps.
I realized that the “small input box” theory seems to be the culprit. When clicking the label, even though it looks like everything is selected, it sometimes only captures the text that is currently visible within the text box. Any content that requires scrolling or is hidden below the fold doesn’t get copied correctly.
For example, if the content has four paragraphs but the text box is small and only shows the first two paragraphs, then only those first two paragraphs are copied.
In the meantime, I found two potential workarounds you can use:
- The Scroll Method: If you scroll down to the very end of the text box manually and then click the label/F2 to select, the copy-paste behavior seems to reset and work correctly for that session until you close the file.
- Resizing: If you increase the height/size of the input text box in Design View to show more lines, the "select all" via label click becomes much more reliable.
Please keep in mind that this is a peer‑to‑peer community where users help other users. As such, I don’t have sufficient tools or backend access to directly fix this issue. Because of that, I highly recommend reporting it to Microsoft so it can be properly investigated. You can submit feedback by going to Help > Feedback or choose Contact Support via the Help tab in the Access ribbon. You may also post this on the Microsoft Feedback Portal to help raise visibility with Microsoft engineers.
Sorry for any inconvenience and thank you for your understanding.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.