Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Export Report to Word

    Is there any way to export a report to Word97 from Access97 so that the fields that are checkboxes (both checked and unchecked) remain unchanged during the transfer ? The standard 'publish it with Word' drops the checkboxes altogether.

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export Report to Word

    This may not be very elegant, but I've used it and it does work. Create TEXT boxes in the report to reflect the value of the Check Boxes i.e. in the Control Source enter something along the lines of =IIf([chkmycheck],"*",""). Text boxes will export to Word. I used asterisk in this example, but there is a check mark available in Wingding Font, (can't remember what it is). Hope that helps.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Export Report to Word

    Something like that is probably the only way to do this using the 'publish to Word' feature. Unfortunately, the rtf file created when publishing to Word drops all graphics, including checkboxes.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •