Copy Macro

[Tezdread]

Hi, I have a form that displays my Question & Answer fields from my FAQ table. I have made a macro to copy the selected text from either the question or answer field in the table and then output it to a txt file.

I have assigned this macro to a command button but when I click it I get the following meesage.

The command or action 'Copy' isn't available now.
* You may be in a read-only database or an uncovered database from an earlier version fo FAQ Database
* The type of object the action applies to isn't currently selected or isn't in the active view.

Use only those commands and macro actions that are currently available for this database.

As far as I know copy is available. When I select the text in one of the fields within the table I can either use the main edit menu to copy, or I can right click on copy that way so it must be active?

Any suggestions welcome!

Thanks in advance

Tezdread
"With every solution comes a new problem"

 

[The_Doc_Man]

When you say "Copy" - what method or function did you actually use in your macro?

If it was either the Copy action or the CopyObject action, I believe the following part of your error message is the thing Access is trying to tell you.

"The type of object the action applies to isn't currently selected or isn't in the active view."

Neither of those actions applies to copying the contents of a single field.