Copying multiple fields to clipboard

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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]
 
Back
Top