Guest_imported
New member
- Jan 1, 1970
- 0
I am setting up a publications distribution database which includes records existing solely to be printed out as instructions for what do to with the other labels. I have 9 different mail label reports for 9 different publications, with dummy entries marked by having '999' in the field which identifies the quantity required of each publication. I would like these dummy labels to print in italics so they stand out a bit from the real labels but conditional formatting doesn't seem to be available in mail labels.
I already have a function in the 'on print' command of the details properties (part of a script from Microsoft allowing printing on partially-used labels) which reads:
Function LabelLayout(R As Report)
If BlankCount& < LabelBlanks& Then
R.NextRecord = False
R.PrintSection = False
BlankCount& = BlankCount& + 1
End If
End Function
Is it possible to add something to this, or to have a second script referred to in the 'on print' bit? If so, what should it read?
Or alternatively, could I add a unbound textbox to the label detail section with something like =Iff([annualreport]=999, fontitalic=true, false) (I already know this particular example is wrong but is it possible to have something similar?)
Any help would be appreciated.
Wendy
I already have a function in the 'on print' command of the details properties (part of a script from Microsoft allowing printing on partially-used labels) which reads:
Function LabelLayout(R As Report)
If BlankCount& < LabelBlanks& Then
R.NextRecord = False
R.PrintSection = False
BlankCount& = BlankCount& + 1
End If
End Function
Is it possible to add something to this, or to have a second script referred to in the 'on print' bit? If so, what should it read?
Or alternatively, could I add a unbound textbox to the label detail section with something like =Iff([annualreport]=999, fontitalic=true, false) (I already know this particular example is wrong but is it possible to have something similar?)
Any help would be appreciated.
Wendy
