Generating a report or form where you can grab formatted data...

[marie515]

Hello,

I would like to generate a report or a form which will be formatted in a particular way (see example below)which can then allow the user to "grab" using their mouse and retain the formatting of the content so that it might be pasted it into another program.

Is this possible?

Example of formatted content that i want to be able to grab and paste into another program (outside of Access):

Summary

As a user of this tool, I would like to ....

Requirements

As a user, I would like to do xxx

etc.

Thanks.

 

[randy700]

How about something like this to copy the data to the clipboard?

Private Sub cmdGrabData_Click()
    Me.txtTextBoxName.SetFocus
    DoCmd.RunCommand acCmdCopy
End Sub

Randy

 

[marie515]

Thank you very much Randy!

So, I'm confused (not unusual)

I have a button that opens a form which I want the contents of that form copied.

So, do I add the code you provided to the "on click" Event Procedure?

See below what I see when i click this -- where does this new code get added?
-------
Private Sub Command261_Click()
On Error GoTo Err_Command261_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "FrmMemberMingleRequest"

stLinkCriteria = "[ID]=" & Me![ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
--------

 

[randy700]

Haven't tested this, but I'd put the code in after the new form is open or in the Open event of the new form itself. If you add it to the 'calling' form, you'll need to include the form name in place of Me. Something like Forms!formname.textboxname.

Randy