2002 ignoring transparent border property

[paradiso]

Hello all,

I have converted a database from 97 to 2002. In several of my reports, some of the text boxes in the detail section print with borders while others do not. The border-related properties of these controls are identical -- all set to transparent. The boxes do not appear in the preview, but do show up on the printout.

This db has a lot of reports, so recreating them is not my first option.

Thank you in advance for suggestions.

 

[jiqjaq]

Are you using the same machine for 2002 as for 97? Same printer? If not, you may be using different print drivers which will cause this problem. Some older model printers are not fully compatible with the new drivers. Also make sure that you bring the textboxes to the front in case there's other fields underneath.

What you can do is change the BorderColor to be the same as the BackColor. Try it on one report. If it works, you've got a driver issue which you can work around, painful as it may be. (but fairly easy in code). If you still see borders, you've got other issues.

To change the BorderColor for all textboxes in the Detail Section, in Report_Open code:

Dim ctl As Control

For Each ctl In Me.Detail.Controls
If TypeOf ctl Is TextBox Then
ctl.BorderColor = ctl.BackColor
End If
Next ctl