Public Calendar Form and Printing

I have created custom form for a Public calendar. Which I have some checkbox
yes/no fields.
For Example (Need Tables check for yes.) When I print that appointment the
fields shows a 0 or -1.
Is there away to have it print yes or no. I have tried yes/no and Icon format

I was told from Sue Mosher, Outlook MVP The following below

(Those are the values stored for Yes/No fields. If you want to show
something else, you'll need to write code to use the text "Yes" when the
value is -1, etc/.)

I'm looking for help with this coding.
As my Exec Director likes the form but thinks the -1 on the printout is
confusing.

I think my response that you quoted was in response to someone who was using VBScript code behind the form to send the data to Word for printing. It's not at all clear from your post how you're printing the form.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"JoeS" <JoeS@discussions.microsoft.com> wrote in message news:49350C96-8FBF-4ECF-995C-24D77CB2A665@microsoft.com...
>I have created custom form for a Public calendar. Which I have some checkbox
> yes/no fields.
> For Example (Need Tables check for yes.) When I print that appointment the
> fields shows a 0 or -1.
> Is there away to have it print yes or no. I have tried yes/no and Icon format
>
> I was told from Sue Mosher, Outlook MVP The following below
>
> (Those are the values stored for Yes/No fields. If you want to show
> something else, you'll need to write code to use the text "Yes" when the
> value is -1, etc/.)
>
> I'm looking for help with this coding.
> As my Exec Director likes the form but thinks the -1 on the printout is
> confusing.
>
>
>

Hi Sue :

To clarify: I have created a custom appointment form for our facility Use
where our Facilites Manager can post to a room to help with setting up for an
event.

I have some check boxes for example ( need tables check for yes). My
Executive Director likes the form but when we use Outlook 2003 to print the
custom appointment in memo style the check boxes print 0 or -1 the data
stored in those fields. My Exec Dir thinks that is too confusing and would
like it to say yes or no .

Is there a way to have the memo change that field to yes or no or is there
a better way.

"Sue Mosher [MVP-Outlook]" wrote:

> I think my response that you quoted was in response to someone who was using VBScript code behind the form to send the data to Word for printing. It's not at all clear from your post how you're printing the form.
>
> --
> Sue Mosher, Outlook MVP
> Author of Configuring Microsoft Outlook 2003
> http://www.turtleflock.com/olconfig/index.htm
> and Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
> "JoeS" <JoeS@discussions.microsoft.com> wrote in message news:49350C96-8FBF-4ECF-995C-24D77CB2A665@microsoft.com...
> >I have created custom form for a Public calendar. Which I have some checkbox
> > yes/no fields.
> > For Example (Need Tables check for yes.) When I print that appointment the
> > fields shows a 0 or -1.
> > Is there away to have it print yes or no. I have tried yes/no and Icon format
> >
> > I was told from Sue Mosher, Outlook MVP The following below
> >
> > (Those are the values stored for Yes/No fields. If you want to show
> > something else, you'll need to write code to use the text "Yes" when the
> > value is -1, etc/.)
> >
> > I'm looking for help with this coding.
> > As my Exec Director likes the form but thinks the -1 on the printout is
> > confusing.
> >
> >
> >
>

You could put create formula fields with formulas that return the strings Yes and No and place them on a hidden page. In the Properties dialog for those text box controls and for the check boxes, you can choose whether or not that field appears in printouts and saves.

For other solutions, see http://www.outlookcode.com/d/customprint.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"JoeS" <JoeS@discussions.microsoft.com> wrote in message news:5741D54E-F3A9-43CC-9B00-859E5E38C0B8@microsoft.com...
> Hi Sue :
>
> To clarify: I have created a custom appointment form for our facility Use
> where our Facilites Manager can post to a room to help with setting up for an
> event.
>
> I have some check boxes for example ( need tables check for yes). My
> Executive Director likes the form but when we use Outlook 2003 to print the
> custom appointment in memo style the check boxes print 0 or -1 the data
> stored in those fields. My Exec Dir thinks that is too confusing and would
> like it to say yes or no .
>
> Is there a way to have the memo change that field to yes or no or is there
> a better way.
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> I think my response that you quoted was in response to someone who was using VBScript code behind the form to send the data to Word for printing. It's not at all clear from your post how you're printing the form.
>>
>> --
>> Sue Mosher, Outlook MVP
>> Author of Configuring Microsoft Outlook 2003
>> http://www.turtleflock.com/olconfig/index.htm
>> and Microsoft Outlook Programming - Jumpstart for
>> Administrators, Power Users, and Developers
>> http://www.outlookcode.com/jumpstart.aspx
>>
>> "JoeS" <JoeS@discussions.microsoft.com> wrote in message news:49350C96-8FBF-4ECF-995C-24D77CB2A665@microsoft.com...
>> >I have created custom form for a Public calendar. Which I have some checkbox
>> > yes/no fields.
>> > For Example (Need Tables check for yes.) When I print that appointment the
>> > fields shows a 0 or -1.
>> > Is there away to have it print yes or no. I have tried yes/no and Icon format
>> >
>> > I was told from Sue Mosher, Outlook MVP The following below
>> >
>> > (Those are the values stored for Yes/No fields. If you want to show
>> > something else, you'll need to write code to use the text "Yes" when the
>> > value is -1, etc/.)
>> >
>> > I'm looking for help with this coding.
>> > As my Exec Director likes the form but thinks the -1 on the printout is
>> > confusing.
>> >
>> >
>> >
>>