 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Programming Forms / April 2008Customize printing without programming
Can someone help me? I have created a form in Outlook 2002 - When it prints the fields they appear in ABC order (Not a real problem) but it print the value as -1 or 0. In addition, all the fields print even when they are not selected. I cannot change the value field because it is grayed out - I am not a programmer - I do not know VBA – but how can I make it print the only the fields the users has selected and print the values I that would like created when selected. not the -1 or 0. Thanks in advance! Jlynn -1 and 0 are the values that Outlook actually stores for a Yes/No field. If you want somethign else to print, you'll need to change the form in two ways: 1) On the Validation tab for the control for that property, set that property not to print or save. 2) Add a formula field to the form that can return whatever text you want to print out, e.g.: IIf([MyField] = True, "Yes", "No") As you can see, some programming is necessary, but VBA plays no part. All you should need is a simple formula. I don't know what you mean by "print only the fields the user has selected," as Outlook has no concept of selecting fields on an item. Printing is an all or nothing affair, subject to the customization I described in #1 above.  SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 > Can someone help me? > I have created a form in Outlook 2002 - When it prints the fields they [quoted text clipped - 8 lines] > Thanks in advance! > Jlynn Thanks for the quick response - I will give this a try and post my progress tomorrow. Do you have a recommended book for beginners on how to create simple functions? I nee to start off very simple - Thanks alot! > -1 and 0 are the values that Outlook actually stores for a Yes/No field. If you want somethign else to print, you'll need to change the form in two ways: > [quoted text clipped - 20 lines] > > Thanks in advance! > > Jlynn You don't really need a book for that (and there isn't one just on that topic, although you might want to see my signature). The formula editor has all the functions available to you. SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 > Do you have a recommended book for beginners on how to create simple > functions? I nee to start off very simple - Thanks alot! [quoted text clipped - 10 lines] >> >> I don't know what you mean by "print only the fields the user has selected," as Outlook has no concept of selecting fields on an item. Printing is an all or nothing affair, subject to the customization I described in #1 above. >> > Can someone help me? >> > I have created a form in Outlook 2002 - When it prints the fields they [quoted text clipped - 8 lines] >> > Thanks in advance! >> > Jlynn |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.