OnFormat action not executed when exporting to PDF

I have some reports that utilize the section onformat action to change a
textbox's fontweight depending on field value... This works great both on
report print and preview!

With 2007 SP1, we have the ability to create pdf's directly from access
which is great! But it seems that the onformat code is not executed in this
case...!

To reproduce, we can make a simple report:

create an emtpy report in design mode.
add 2 text boxes.
set the control source to ="TEXT" for both.
on one of the controls onformat event, add code to make the text bold:
Me.Text1.FontWeight=1000

Save the report as Report1.

if you open the report in print preview (or if you print it), you'll see
that one of the "TEXT" messages are in bold.

Now, open the vba editor and in the direct window type:
docmd.OutputTo acOutputReport
,"Report1",acFormatPDF,"c:\Report1.pdf",true,,,acE xportQualityPrint
A pdf file is created and opened in your pdf viewer. Notice that this time,
none of the text boxes are in bold!

Is this by design or is it a bug? Any ideas how to get around it?

Hi Hakan,

I tried your test case, and found that with Me.Text1.FontWeight=1000 I got
the behaviour you describe. However, if I change that to
Me.Text1.FontWeight=700 (using the value given in the help file for
enumeration of the Bold constant), then the PDF file (and the print preview)
does show bold text.

HTH,

Rob


"Hakan Naslund" wrote in message
...
I have some reports that utilize the section onformat action to change a
textbox's fontweight depending on field value... This works great both on
report print and preview!

With 2007 SP1, we have the ability to create pdf's directly from access
which is great! But it seems that the onformat code is not executed in
this
case...!

To reproduce, we can make a simple report:

create an emtpy report in design mode.
add 2 text boxes.
set the control source to ="TEXT" for both.
on one of the controls onformat event, add code to make the text bold:
Me.Text1.FontWeight=1000

Save the report as Report1.

if you open the report in print preview (or if you print it), you'll see
that one of the "TEXT" messages are in bold.

Now, open the vba editor and in the direct window type:
docmd.OutputTo acOutputReport
,"Report1",acFormatPDF,"c:\Report1.pdf",true,,,acE xportQualityPrint
A pdf file is created and opened in your pdf viewer. Notice that this
time,
none of the text boxes are in bold!

Is this by design or is it a bug? Any ideas how to get around it?

Ahh, thanks Rob!

I will try that! Strange behaviour though...

Hakan

"Rob Parker" wrote:

Hi Hakan,

I tried your test case, and found that with Me.Text1.FontWeight=1000 I got
the behaviour you describe. However, if I change that to
Me.Text1.FontWeight=700 (using the value given in the help file for
enumeration of the Bold constant), then the PDF file (and the print preview)
does show bold text.

HTH,

Rob


"Hakan Naslund" wrote in message
...
I have some reports that utilize the section onformat action to change a
textbox's fontweight depending on field value... This works great both on
report print and preview!

With 2007 SP1, we have the ability to create pdf's directly from access
which is great! But it seems that the onformat code is not executed in
this
case...!

To reproduce, we can make a simple report:

create an emtpy report in design mode.
add 2 text boxes.
set the control source to ="TEXT" for both.
on one of the controls onformat event, add code to make the text bold:
Me.Text1.FontWeight=1000

Save the report as Report1.

if you open the report in print preview (or if you print it), you'll see
that one of the "TEXT" messages are in bold.

Now, open the vba editor and in the direct window type:
docmd.OutputTo acOutputReport
,"Report1",acFormatPDF,"c:\Report1.pdf",true,,,acE xportQualityPrint
A pdf file is created and opened in your pdf viewer. Notice that this
time,
none of the text boxes are in bold!

Is this by design or is it a bug? Any ideas how to get around it?