Cut and paste problem.

[Frank Martin]

I have my own Access2003 business
application.

I have address fields and address queries,
subforms, and reports derived from these for
the printing of tickets for parcels and some
envelopes, and this all works well.

But I have come across a problem. All I
want to do is show, say, a label with a
customer address in the report screen and
then copy this with CtrlC.

Then all I want to do is paste this and its
same format into Word2003 as the address
block in a letterhead.

But I cannot get this to happen. Can
someone advise me how this should be done?

Please help, Frank

 

[tina]

suggest you use a *form* to display the data, then you'll be able to
highlight it and copy/paste using the standard keyboard shortcuts.

hth

 

[Frank Martin]

Thanks, I have tried this but all that
happens is that one field only is copied.

How can I copy all fields at once. Using a
datasheet doesn't work either because the
column headers are copied at the same time.

Regards, Frank

 

[tina]

add an unbound textbox control to your form, and set its' ControlSource to
an expression that concatenates the address fields. for instance, let's say
your table has the following address fields, as

Address1
Address2
City
State
ZIP

you can set the control's ControlSource property to

= [Address1] & Chr(13) & Chr(10) & [Address2] & Chr(13) & Chr(10) & [City] &
", " & [State] & " " & [ZIP]

the control will display the address as

123 Main Street
Suite 500
Los Angeles, CA 90210

you should be able to highlight the entire contents of the control, and
copy/paste.

hth

 

[Frank Martin]

Thanks. This is more like what I wanted. I'll
try this & let you know.
Regards.

add an unbound textbox control to your
form, and set its' ControlSource to
an expression that concatenates the address
fields. for instance, let's say
your table has the following address
fields, as

Address1
Address2
City
State
ZIP

you can set the control's ControlSource
property to

= [Address1] & Chr(13) & Chr(10) &
[Address2] & Chr(13) & Chr(10) & [City] &
", " & [State] & " " & [ZIP]

the control will display the address as

123 Main Street
Suite 500
Los Angeles, CA 90210

you should be able to highlight the entire
contents of the control, and
copy/paste.

hth


message

Thanks, I have tried this but all that
happens is that one field only is copied.

How can I copy all fields at once.
Using a
datasheet doesn't work either because the
column headers are copied at the same
time.

Regards, Frank


message