Turning-off "Copied to Clipboard" Message

[Jim Bough]

After copying data into a new record, I get the following
message when closing the form:

"You copied a large amount of data onto the clipboard."

How can I program the form so that this message does NOT
appear?

 

[John Vinson]

After copying data into a new record, I get the following
message when closing the form:

"You copied a large amount of data onto the clipboard."

How can I program the form so that this message does NOT
appear?

One way would be by not using the clipboard at all: there are lots
better techniques! A few questions:

- Would it suffice to have new records Default certain fields to the
previous record's value? If so, you can set the Default property of
form controls to their current value in the Form's AfterUpdate event:

Me!txtThis.Default = Chr(34) & Me!txtThis & Chr(34)

- Why does your table have multiple records with identical values? Are
you sure the table structure is properly normalized?

- If you need to copy and paste multiple records, an Append query
might be more efficient and less intrusive.