Copy/Print text form memo field?

[Shyguy]

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

[Dennys G.]

Re: Copy/Print text form memo field?

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" <Shyguy@shytown .com> wrote in message
news:huo4lv4esf 65u7oggsnakatou ahmd4c1n2@4ax.c om...[color=blue]
> 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[/color]

[Shyguy]

Re: Copy/Print text form memo field?

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." <giaruso@adelph ia.net>
wrote:
[color=blue]
>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" <Shyguy@shytown .com> wrote in message
>news:huo4lv4es f65u7oggsnakato uahmd4c1n2@4ax. com...[color=green]
>> 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[/color]
>[/color]

[Dennys G.]

Re: Copy/Print text form memo field?

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" <Shyguy@shytown .com> wrote in message
news:ra86lvora8 vo7mbr0s4qsq62i keis50g0n@4ax.c om...[color=blue]
> 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." <giaruso@adelph ia.net>
> wrote:
>[color=green]
> >Consider using the "Can Grow" and "Can Shrink" properties of the memo[/color][/color]
text[color=blue][color=green]
> >box on your report. This way, the text box will adjust to the size of[/color][/color]
your[color=blue][color=green]
> >text. You then do not have to make a large text box.
> >Denny G.
> >
> >
> >"Shyguy" <Shyguy@shytown .com> wrote in message
> >news:huo4lv4es f65u7oggsnakato uahmd4c1n2@4ax. com...[color=darkred]
> >> 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[/color]
> >[/color]
>[/color]

[Dennys G.]

Re: Copy/Print text form memo field?

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.GoToContr ol "place the name of your memo field between these
quotes"
DoCmd.RunComman d acCmdCopy
The text from the memo field for the current form will be in your clipboard.

I hope this helps:~)

Denny G.


"Shyguy" <Shyguy@shytown .com> wrote in message
news:ra86lvora8 vo7mbr0s4qsq62i keis50g0n@4ax.c om...[color=blue]
> 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." <giaruso@adelph ia.net>
> wrote:
>[color=green]
> >Consider using the "Can Grow" and "Can Shrink" properties of the memo[/color][/color]
text[color=blue][color=green]
> >box on your report. This way, the text box will adjust to the size of[/color][/color]
your[color=blue][color=green]
> >text. You then do not have to make a large text box.
> >Denny G.
> >
> >
> >"Shyguy" <Shyguy@shytown .com> wrote in message
> >news:huo4lv4es f65u7oggsnakato uahmd4c1n2@4ax. com...[color=darkred]
> >> 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[/color]
> >[/color]
>[/color]

[Dennys G.]

Re: Copy/Print text form memo field?

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" <Shyguy@shytown .com> wrote in message
news:cu27lvsg05 lc6r4f4iocfgfsm r8rfms1lb@4ax.c om...[color=blue]
> 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." <giaruso@adelph ia.net>
> wrote:
>[color=green]
> >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.GoToContr ol "place the name of your memo field between[/color][/color]
these[color=blue][color=green]
> >quotes"
> > DoCmd.RunComman d acCmdCopy
> >The text from the memo field for the current form will be in your[/color][/color]
clipboard.[color=blue][color=green]
> >
> >I hope this helps:~)
> >
> >Denny G.
> >
> >
> >"Shyguy" <Shyguy@shytown .com> wrote in message
> >news:ra86lvora 8vo7mbr0s4qsq62 ikeis50g0n@4ax. com...[color=darkred]
> >> 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." <giaruso@adelph ia.net>
> >> wrote:
> >>
> >> >Consider using the "Can Grow" and "Can Shrink" properties of the memo[/color]
> >text[color=darkred]
> >> >box on your report. This way, the text box will adjust to the size of[/color]
> >your[color=darkred]
> >> >text. You then do not have to make a large text box.
> >> >Denny G.
> >> >
> >> >
> >> >"Shyguy" <Shyguy@shytown .com> wrote in message
> >> >news:huo4lv4es f65u7oggsnakato uahmd4c1n2@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[/color][/color][/color]
to[color=blue][color=green][color=darkred]
> >> >> accommodate memo fields with a lot of text.
> >> >>
> >> >> Thanks for any help,
> >> >>
> >> >> ShyGuy
> >> >
> >>[/color]
> >[/color]
>[/color]

[Shyguy]

Re: Copy/Print text form memo field?

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 Takeitbaby2003@ 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." <giaruso@adelph ia.net>
wrote:
[color=blue]
>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" <Shyguy@shytown .com> wrote in message
>news:cu27lvsg0 5lc6r4f4iocfgfs mr8rfms1lb@4ax. com...[color=green]
>> 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." <giaruso@adelph ia.net>
>> wrote:
>>[color=darkred]
>> >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.GoToContr ol "place the name of your memo field between[/color][/color]
>these[color=green][color=darkred]
>> >quotes"
>> > DoCmd.RunComman d acCmdCopy
>> >The text from the memo field for the current form will be in your[/color][/color]
>clipboard.[color=green][color=darkred]
>> >
>> >I hope this helps:~)
>> >
>> >Denny G.
>> >
>> >
>> >"Shyguy" <Shyguy@shytown .com> wrote in message
>> >news:ra86lvora 8vo7mbr0s4qsq62 ikeis50g0n@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." <giaruso@adelph ia.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" <Shyguy@shytown .com> wrote in message
>> >> >news:huo4lv4es f65u7oggsnakato uahmd4c1n2@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[/color][/color]
>to[color=green][color=darkred]
>> >> >> accommodate memo fields with a lot of text.
>> >> >>
>> >> >> Thanks for any help,
>> >> >>
>> >> >> ShyGuy
>> >> >
>> >>
>> >[/color]
>>[/color]
>[/color]