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.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Jlynn" Jlynn @discussions.microsoft.com wrote in message ...
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

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!

"Sue Mosher [MVP-Outlook]" wrote:

-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.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Jlynn" Jlynn @discussions.microsoft.com wrote in message ...
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

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.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Jlynn" wrote in message ...

Do you have a recommended book for beginners on how to create simple
functions? I nee to start off very simple - Thanks alot!

"Sue Mosher [MVP-Outlook]" wrote:

-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.


"Jlynn" Jlynn @discussions.microsoft.com wrote in message ...
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