So one the button for the new line which is just the code below creates the new line:
Me.Text50 = Me.Text50 & vbCrLf
The button to paste (the code below) is the one that should paste, however it pastes on the first line only. Not the new line that was created.
Me.Text50.SetFocus
DoCmd.RunCommand...
Gotcha, so I replaced it but now it's just not pasting. It's kinda weird but I've switched it around and the only function that happens it the new line but not the paste.
So for some reason, it forces my access database to completely close. It does paste, but it doesn't add the new line. I even tried to switch it around and it doesn't work
Yes, it is a Long Text with Rich Text format. I am trying to move away from basically having to click in the textbox and pressing enter to go to a newline. I am creating this to log in a single text all actions being done in the access sheet but for now using a button to paste the most recent...
So this is what I have:
Private Sub Toggle70_Click()
Me.textbox.SetFocus
DoCmd.RunCommand acCmdPaste
End Sub
The thing is that I am unsure how to add the VbCrLf into this. I have tried many ways but each time doesn't work. I might be doing it wrong, can you give an example?
So I may be dumb for asking, but I am working on make a log using a single text box within a form. I would like there to be button where it pastes the most recent item in my clipboard in the text box each time I press the button. However, I have no idea if it is even possible to place a...