Copying multiple fields to clipboard

[Guest]

I created a form with the following fields: STREET, CITY, STATE, ZIP.
I want to create a button with Visual Basic code behind it that copies the
contents of these fields to the clipboard as a single text object in the
following format...

STREET
CITY, STATE ZIP

Any sugggestions on how i might go about doing this?
Thanks in advance. H.M.

 

[John Vinson]

I created a form with the following fields: STREET, CITY, STATE, ZIP.
I want to create a button with Visual Basic code behind it that copies the
contents of these fields to the clipboard as a single text object in the
following format...

STREET
CITY, STATE ZIP

Any sugggestions on how i might go about doing this?
Thanks in advance. H.M.

I'd suggest putting a concatenated field either in the form's
Recordsource query, or as the control source of a textbox on the form:

[Street] & Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip]

and exporting this field.


John W. Vinson[MVP]