Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

2002 ignoring transparent border property

Status
Not open for further replies.

paradiso

Programmer
Apr 18, 2002
60
US
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.

 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top