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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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")
 
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


Rick B said:
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



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



Elise said:
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


Rick B said:
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



Elise said:
I have a report that is written in acess. I want to e-mail it. When
Click to expand...
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
Click to expand...
happened.
Is
there a way to export these fields?
Click to expand...
Click to expand...
Click to expand...
 
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


Rick B said:
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



Elise said:
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


Rick B said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top