Copy and Paste corrupt from ListBox

[david epsom dot com dot au]

I have a number of list boxes where if I do "copy and paste" from the list
box to Word (or anything) the text comes across as rubish characters. It
does not affect all my forms. All listbox are unbound, all use queries as
rowsource.

Here is a sample!
???4???????????????4???


Does anyone have an explanation?

(david)

 

[Tony C]

Hello David

Are you trying to copy the Data from the List Box to the
Clipboard? If you are then you cannot do this.

However you could try setting up a command buton to either
export the Query to another file format, or if you are
wanting to just export the data within the list box, you
could try using a file to "Output" the list box contents
to the file by using the VB command Print. If you send me
your e-mail address to
to&ny.ch&or&ley@al&fre&dmc&a&&lp&ineplc.com (remove the
spam blocks '&'), I shall type up an example on how to do
this and I'll send it to you on Monday.

HTH



Tony C.

 

[david epsom dot com dot au]

Are you trying to copy the Data from the List Box to the

Clipboard? If you are then you cannot do this.

I just created a new form in the same database, and I can do
it. Also the same form when saved in A97 format. When you
say "cannot do this", do you mean that it is unreliable
for some reason?

Here are some working copy & paste examples:
127
rptIRP_TransList


(david)