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 6 10433
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
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
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
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
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 >
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 >> > >> > This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |