If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
OnFormat action not executed when exporting to PDF
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? |
#3
|
|||
|
|||
OnFormat action not executed when exporting to PDF
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? |
Thread Tools | |
Display Modes | |
|
|