Refreshing a report before printing it...

[LRHatBSSS]

Hey folks,


Should be a simple task but...

In a small application the user has the ability to decide a few characteristics of the fields to be printed in a report cover (what font size, bold: yes / no, Italic: yes / no).

Problem is although I’m changing the properties for the fields (using the On Activate event trap) the final print it’s not affected, I mean, the fields print with the default properties set and not the ones changed based on the values established by the user.

By the way, the report is open using “DoCmd.OpenReport stDocName, acNormal”, so it does not show on the screen before being printed.

Any help is greatly appreciated.


LRH



L.R. Humberto

If you don't know where you are going to, doesn't matter how fast you are going, you'll never get there.

 

[PHV]

Open the report in design view.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[LRHatBSSS]

Thx, PHV, but I need to avoid that. That idea is to click a button and have the cover printed, no preview.

L.R. Humberto

If you don't know where you are going to, doesn't matter how fast you are going, you'll never get there.

 

[PHV]

DoCmd.OpenReport stDocName, acViewDesign, , ,acHidden
' Stuff changing the properties for the fields here
DoCmd.Close acReport, stDocName, acSaveYes
DoCmd.OpenReport stDocName, acViewNormal

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[LRHatBSSS]

Hi PH,

Thx again, but that did not solved the problem either.

Anyway, I found the solution: I used the On Format trap event for the section where the affected fields are placed and it worked just fine.

Again, thx for your time.


L.R. Humberto

If you don't know where you are going to, doesn't matter how fast you are going, you'll never get there.