export the value of a yes/no field to word or excel

[Elise]

I have a report that is written in acess. I want to e-mail it. When I try
to send it as a word document the values of all the yes/no fields are not
there. I tried to export the table to excel but the same thing happened. Is
there a way to export these fields?

 

[Rick B]

Change your report to display an actual field. Remove the current control
and add an unbound text box...

=IIf([SomeFieldNme],"X","")

or

=IIf([SomeFieldNme],"Yes","No")

or

=IIf([SomeFieldNme],"True","False")

 

[Elise]

Thanks, that works great. I don't suppose you can tell me how to get my
graffic logo to export to a word document too?
--
Elise King-Lynch

Change your report to display an actual field. Remove the current control
and add an unbound text box...

=IIf([SomeFieldNme],"X","")

or

=IIf([SomeFieldNme],"Yes","No")

or

=IIf([SomeFieldNme],"True","False")


--
Rick B

I have a report that is written in acess. I want to e-mail it. When I try
to send it as a word document the values of all the yes/no fields are not
there. I tried to export the table to excel but the same thing happened. Is
there a way to export these fields?

 

[Rick B]

You'd need to use a snapshot format, or save it as a pdf using a third
party. RTF format does not preserve all the formatting that you have set up
in Access.

--
Rick B

Thanks, that works great. I don't suppose you can tell me how to get my
graffic logo to export to a word document too?
--
Elise King-Lynch

Change your report to display an actual field. Remove the current control
and add an unbound text box...

=IIf([SomeFieldNme],"X","")

or

=IIf([SomeFieldNme],"Yes","No")

or

=IIf([SomeFieldNme],"True","False")


--
Rick B

I have a report that is written in acess. I want to e-mail it. When

I
try

to send it as a word document the values of all the yes/no fields are not
there. I tried to export the table to excel but the same thing

happened.
Is

there a way to export these fields?

 

[Elise]

That sounds way over my head. I'm happy to get the data over. I'll have to
leave the logo for another day. Thanks again for your help.
--
Elise King-Lynch

You'd need to use a snapshot format, or save it as a pdf using a third
party. RTF format does not preserve all the formatting that you have set up
in Access.

--
Rick B

Thanks, that works great. I don't suppose you can tell me how to get my
graffic logo to export to a word document too?
--
Elise King-Lynch

Change your report to display an actual field. Remove the current control
and add an unbound text box...

=IIf([SomeFieldNme],"X","")

or

=IIf([SomeFieldNme],"Yes","No")

or

=IIf([SomeFieldNme],"True","False")


--
Rick B



I have a report that is written in acess. I want to e-mail it. When I
try
to send it as a word document the values of all the yes/no fields are not
there. I tried to export the table to excel but the same thing happened.
Is
there a way to export these fields?