472,805 Members | 963 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,805 software developers and data experts.

Copy/Print text form memo field?

I want to create two buttons on a form. One would allow the user to
Copy the contents of the current records memo field, the other would
allow them to print. I set up a report based on the memo field, and
it works. But, it seems wrong since I had to create a huge text box to
accommodate memo fields with a lot of text.

Thanks for any help,

ShyGuy
Nov 12 '05 #1
6 10363
Consider using the "Can Grow" and "Can Shrink" properties of the memo text
box on your report. This way, the text box will adjust to the size of your
text. You then do not have to make a large text box.
Denny G.
"Shyguy" <Sh****@shytown.com> wrote in message
news:hu********************************@4ax.com...
I want to create two buttons on a form. One would allow the user to
Copy the contents of the current records memo field, the other would
allow them to print. I set up a report based on the memo field, and
it works. But, it seems wrong since I had to create a huge text box to
accommodate memo fields with a lot of text.

Thanks for any help,

ShyGuy

Nov 12 '05 #2
Thanks for the tip. That works very nicely. ;-)
I still haven't figured out how to copy the text to the clipboard.

ShyGuy

On Sun, 31 Aug 2003 22:43:25 GMT, "Dennys G." <gi*****@adelphia.net>
wrote:
Consider using the "Can Grow" and "Can Shrink" properties of the memo text
box on your report. This way, the text box will adjust to the size of your
text. You then do not have to make a large text box.
Denny G.
"Shyguy" <Sh****@shytown.com> wrote in message
news:hu********************************@4ax.com.. .
I want to create two buttons on a form. One would allow the user to
Copy the contents of the current records memo field, the other would
allow them to print. I set up a report based on the memo field, and
it works. But, it seems wrong since I had to create a huge text box to
accommodate memo fields with a lot of text.

Thanks for any help,

ShyGuy


Nov 12 '05 #3
I am missing something. May I ask your reason for wanting to copy to the
clipboard? If all you want to do is print out the text in the memo field,
simply build a report with a memo-text box (as I thought you did) off the
table containing the memo field data. Then print the report. You do not
have to copy to the clipboard to do this in MS Access.
Denny G.
"Shyguy" <Sh****@shytown.com> wrote in message
news:ra********************************@4ax.com...
Thanks for the tip. That works very nicely. ;-)
I still haven't figured out how to copy the text to the clipboard.

ShyGuy

On Sun, 31 Aug 2003 22:43:25 GMT, "Dennys G." <gi*****@adelphia.net>
wrote:
Consider using the "Can Grow" and "Can Shrink" properties of the memo textbox on your report. This way, the text box will adjust to the size of yourtext. You then do not have to make a large text box.
Denny G.
"Shyguy" <Sh****@shytown.com> wrote in message
news:hu********************************@4ax.com.. .
I want to create two buttons on a form. One would allow the user to
Copy the contents of the current records memo field, the other would
allow them to print. I set up a report based on the memo field, and
it works. But, it seems wrong since I had to create a huge text box to
accommodate memo fields with a lot of text.

Thanks for any help,

ShyGuy

Nov 12 '05 #4
If you must copy the contents of your memo text box on your form to the
clipboard, try this: On your "Copy" button's On Click event, attach the
following code:
DoCmd.GoToControl "place the name of your memo field between these
quotes"
DoCmd.RunCommand acCmdCopy
The text from the memo field for the current form will be in your clipboard.

I hope this helps:~)

Denny G.
"Shyguy" <Sh****@shytown.com> wrote in message
news:ra********************************@4ax.com...
Thanks for the tip. That works very nicely. ;-)
I still haven't figured out how to copy the text to the clipboard.

ShyGuy

On Sun, 31 Aug 2003 22:43:25 GMT, "Dennys G." <gi*****@adelphia.net>
wrote:
Consider using the "Can Grow" and "Can Shrink" properties of the memo textbox on your report. This way, the text box will adjust to the size of yourtext. You then do not have to make a large text box.
Denny G.
"Shyguy" <Sh****@shytown.com> wrote in message
news:hu********************************@4ax.com.. .
I want to create two buttons on a form. One would allow the user to
Copy the contents of the current records memo field, the other would
allow them to print. I set up a report based on the memo field, and
it works. But, it seems wrong since I had to create a huge text box to
accommodate memo fields with a lot of text.

Thanks for any help,

ShyGuy

Nov 12 '05 #5
Your error message would be likely if you are attaching the code to the text
box or somewhere else. Be sure you are attaching the code to the "On Click"
event of the Copy button's properties. What version of MS Access are you
using? I have made up a sample DB you can look at if you wish. I must,
however, e-mail it to your personal e-mail address. Let me know. My
database is for either Access 2000 or XP (2002).

Denny G.
"Shyguy" <Sh****@shytown.com> wrote in message
news:cu********************************@4ax.com...
Thanks for tge reply,

Sorry for not being more clear in my massage. I want to be able to
print the contents of the Memo field, but I alsoI want to be able to
copy and paste the data into onother app, like word or Notepad etc.

I have the printing part done, but still can't get the copy to work.

I tried your suggestion but get an error message that 'the command or
action 'Copy' isn't available now."

I tired later but it still wasn't available. (bat attempt at humour)
;-)

ShyGuy

On Mon, 01 Sep 2003 17:22:11 GMT, "Dennys G." <gi*****@adelphia.net>
wrote:
If you must copy the contents of your memo text box on your form to the
clipboard, try this: On your "Copy" button's On Click event, attach the
following code:
DoCmd.GoToControl "place the name of your memo field between thesequotes"
DoCmd.RunCommand acCmdCopy
The text from the memo field for the current form will be in your clipboard.
I hope this helps:~)

Denny G.
"Shyguy" <Sh****@shytown.com> wrote in message
news:ra********************************@4ax.com.. .
Thanks for the tip. That works very nicely. ;-)
I still haven't figured out how to copy the text to the clipboard.

ShyGuy

On Sun, 31 Aug 2003 22:43:25 GMT, "Dennys G." <gi*****@adelphia.net>
wrote:

>Consider using the "Can Grow" and "Can Shrink" properties of the memo

text
>box on your report. This way, the text box will adjust to the size of

your
>text. You then do not have to make a large text box.
>Denny G.
>
>
>"Shyguy" <Sh****@shytown.com> wrote in message
>news:hu********************************@4ax.com.. .
>> I want to create two buttons on a form. One would allow the user to
>> Copy the contents of the current records memo field, the other would
>> allow them to print. I set up a report based on the memo field, and
>> it works. But, it seems wrong since I had to create a huge text box to >> accommodate memo fields with a lot of text.
>>
>> Thanks for any help,
>>
>> ShyGuy
>

Nov 12 '05 #6
I have the code attached to the Copy buttons "On Click" event, as you
suggested in your previous post. I am using Xp and the Database is
Access 2000 format.

My email is Ta************@yahoo.com. I would like to take a look at
that sample.

Thanks again,
ShyGuy

On Mon, 01 Sep 2003 18:51:32 GMT, "Dennys G." <gi*****@adelphia.net>
wrote:
Your error message would be likely if you are attaching the code to the text
box or somewhere else. Be sure you are attaching the code to the "On Click"
event of the Copy button's properties. What version of MS Access are you
using? I have made up a sample DB you can look at if you wish. I must,
however, e-mail it to your personal e-mail address. Let me know. My
database is for either Access 2000 or XP (2002).

Denny G.
"Shyguy" <Sh****@shytown.com> wrote in message
news:cu********************************@4ax.com.. .
Thanks for tge reply,

Sorry for not being more clear in my massage. I want to be able to
print the contents of the Memo field, but I alsoI want to be able to
copy and paste the data into onother app, like word or Notepad etc.

I have the printing part done, but still can't get the copy to work.

I tried your suggestion but get an error message that 'the command or
action 'Copy' isn't available now."

I tired later but it still wasn't available. (bat attempt at humour)
;-)

ShyGuy

On Mon, 01 Sep 2003 17:22:11 GMT, "Dennys G." <gi*****@adelphia.net>
wrote:
>If you must copy the contents of your memo text box on your form to the
>clipboard, try this: On your "Copy" button's On Click event, attach the
>following code:
> DoCmd.GoToControl "place the name of your memo field betweenthese >quotes"
> DoCmd.RunCommand acCmdCopy
>The text from the memo field for the current form will be in yourclipboard. >
>I hope this helps:~)
>
>Denny G.
>
>
>"Shyguy" <Sh****@shytown.com> wrote in message
>news:ra********************************@4ax.com.. .
>> Thanks for the tip. That works very nicely. ;-)
>> I still haven't figured out how to copy the text to the clipboard.
>>
>> ShyGuy
>>
>> On Sun, 31 Aug 2003 22:43:25 GMT, "Dennys G." <gi*****@adelphia.net>
>> wrote:
>>
>> >Consider using the "Can Grow" and "Can Shrink" properties of the memo
>text
>> >box on your report. This way, the text box will adjust to the size of
>your
>> >text. You then do not have to make a large text box.
>> >Denny G.
>> >
>> >
>> >"Shyguy" <Sh****@shytown.com> wrote in message
>> >news:hu********************************@4ax.com.. .
>> >> I want to create two buttons on a form. One would allow the user to
>> >> Copy the contents of the current records memo field, the other would
>> >> allow them to print. I set up a report based on the memo field, and
>> >> it works. But, it seems wrong since I had to create a huge text boxto >> >> accommodate memo fields with a lot of text.
>> >>
>> >> Thanks for any help,
>> >>
>> >> ShyGuy
>> >
>>
>


Nov 12 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: ivan | last post by:
Access 97 I have a memo field in a footer on a subform. When I print the form, all data is printed except the data that was entered into the memo field. The memo field itself is printed (the...
13
by: MLH | last post by:
I have a form with two controls: !! - combo box !! - text box A button on the form tries to run this SQL when clicked... INSERT INTO BodyMsgsSent (ToWhom, BodyText) SELECT DISTINCTROW !! AS...
0
by: Lauren Wilson | last post by:
The error does not have an error number. It's not even a normal Access error message box. Hope someone has some insight to this problem. I have a form that contains a large (5" x 4") text box...
1
by: Monica Roman | last post by:
Hello, help please. I have a little macro that copies the date from a date/time field to a memo field, BUT instead of going to the memo field it finds the first date/time field and tries to copy...
2
by: alexsg | last post by:
I'm setting up a resolutions database where each resolution will be copied from Word documents and pasted into a memo field. The resolution will be in the form: Resolution title <cr> Project no...
1
by: chris | last post by:
I'm not sure this is even feasible. What I want to do is create a command button. When this command button is pressed, it taes field values and puts them into text format. I think I know how to...
4
by: ACF | last post by:
Hello, I'm programming an application in MS Access 2003 / 2007 and would like to know how I can copy highlighted text to the windows clipboard? I am now using a statement in combination with...
5
by: Bugran | last post by:
I am trying to copy a textbox field on a form (which basically contains the body of a letter) into a memo field in a table (Access 2003) for later printing later. Of course Access queries/SQL will...
0
by: carlton129 | last post by:
Hi! I am trying to copy the current form and subform to the clipboard with the click of a button so that I can paste it in another application. So far, I can get all of the Form info together into...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: lllomh | last post by:
How does React native implement an English player?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.