That sounds like "fun" I suspect it would be awkward in Access.
You can capture individual fields with a mouse click event and the contents
could be stored in a (sparse) array based on the field name and record ID
(Where is MUMPS when you need it?).
That's the simple way.
I suppose you could use the mouse to select but probably not high light an
area. It knows where it is to a certain extend, then run through code to
pick what you want.
KontactKrap wrote:
[Quoted Text] > Hello,
>
> I am using a continuous form to display data to user. Column Names
> (labels) are contained in the Form Header and fields (text boxes) are
> in the Detail section. The form's record source is a simple SQL
> statement with a WHERE clause that limits the records to those
> applicable to that user. I would now like to enable the user to
> highlight (select) a finite number of fields for a finite number of
> records then be able to Copy said selected data to the Windows
> Clipboard. I am familiar with copying data to the Windows Clipboard
> - no help needed there. However, I am clueless as to how I can
> enable the user to perform the field selection as described above. I
> know I can select a single ENTIRE record using: DoCmd.RunCommand
> acCmdSelectRecord
> I can also select All records using:
> DoCmd.RunCommand acCmdSelectAllRecords
> But, selecting only a few fields on a few records within a Continuous
> Form is beyond me. All help is much appreciated!
|