Access, Outlook and check boxes

K

Kathy

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?
 
J

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?
Click to expand...

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]
 
Top