Prev: Images in a Report.
Next: Run report wizard from code
From: MentalDrow on 14 Feb 2005 12:35
I've created my first Access Data Base and I'm happy with the results in
Access (2003). One of the reports I've set up uses Multiple YES/NO check
boxes. The data for the boxes is entered through a form and has it's own
field in the table. They show up in the report (both the yes and no values)
as appropriate however, when I use Office Links to publish it with MS Word
(2003) the check boxes are not present. Their column label is present at the
top of the page but the boxes or even their yes/no values are not present. I
can't even get them to show up as true/false if I send the report to MS
Excel. I'm sure there's an easy fix out there but with my recently acquired
Access skills, I can't find it. Would prefer to have it publish to Word
rather than Excel but will settle for Excel until then.
From: Steve Scott on 14 Feb 2005 13:49
Hi,

I am having exactly the same problem and would be keen to hear the outcome

Rgds

Steve

"MentalDrow" wrote:

> I've created my first Access Data Base and I'm happy with the results in
> Access (2003). One of the reports I've set up uses Multiple YES/NO check
> boxes. The data for the boxes is entered through a form and has it's own
> field in the table. They show up in the report (both the yes and no values)
> as appropriate however, when I use Office Links to publish it with MS Word
> (2003) the check boxes are not present. Their column label is present at the
> top of the page but the boxes or even their yes/no values are not present. I
> can't even get them to show up as true/false if I send the report to MS
> Excel. I'm sure there's an easy fix out there but with my recently acquired
> Access skills, I can't find it. Would prefer to have it publish to Word
> rather than Excel but will settle for Excel until then.
From: Rick B on 14 Feb 2005 14:28
Boxes, lines, etc do not transfer to Word. You can either replace your
boxes with a Yes/No values. Or you could do an IF statement to print an "X"
if true and a blank if False. Or you could simply not send it to Word. If
you want an exact picture of the report, Snapshot format or pdf is the way
to go.

Rick B



"Steve Scott" <SteveScott(a)discussions.microsoft.com> wrote in message
news:1F4C9253-8457-4CFF-B066-0E42BDEAD97C(a)microsoft.com...
> Hi,
>
> I am having exactly the same problem and would be keen to hear the outcome
>
> Rgds
>
> Steve
>
> "MentalDrow" wrote:
>
> > I've created my first Access Data Base and I'm happy with the results in
> > Access (2003). One of the reports I've set up uses Multiple YES/NO
check
> > boxes. The data for the boxes is entered through a form and has it's
own
> > field in the table. They show up in the report (both the yes and no
values)
> > as appropriate however, when I use Office Links to publish it with MS
Word
> > (2003) the check boxes are not present. Their column label is present
at the
> > top of the page but the boxes or even their yes/no values are not
present. I
> > can't even get them to show up as true/false if I send the report to MS
> > Excel. I'm sure there's an easy fix out there but with my recently
acquired
> > Access skills, I can't find it. Would prefer to have it publish to Word
> > rather than Excel but will settle for Excel until then.


 | 
Pages: 1
Prev: Images in a Report.
Next: Run report wizard from code