Access, Outlook and check boxes

[Guest]

I ahve an access form with check boxes that show as yes/no in the table and
the query. I have added the Send object command. Information entered in the
form is transcribed into a an email using rdmessage. However, the yes/no
field revert back to the binary format. I want yes or no to display. How do
i code for this?

 

[John Vinson]

I ahve an access form with check boxes that show as yes/no in the table and
the query. I have added the Send object command. Information entered in the
form is transcribed into a an email using rdmessage. However, the yes/no
field revert back to the binary format. I want yes or no to display. How do
i code for this?

You'll need to create a Query explicitly converting the yes/no fields
(which are in fact internally stored as -1 and 0 respectively). In the
query put calculated fields like

ExpFieldA: IIF(FieldA, "Yes", "No")

This will be a Text field and will export as text.

John W. Vinson[MVP]