By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,401 Members | 793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,401 IT Pros & Developers. It's quick & easy.

Report text box borders automatically reset to solid

P: 23
I created a database in Access 2000 on my PC.
I copied it to a laptop which runs Access 2003 and XP.
I opened the database on the laptop and printed some reports, but the borders of all text boxes on the reports were then somehow reset to “solid”, while I had it “transparent” on the PC.

I changed it back to transparent and I’m not going to try to replicate it again; just wondered if anybody had the same problem. Maybe its got nothing to do with the copying. Maybe I reset something somewhere.
Thanx.
Mar 14 '07 #1
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,627
I created a database in Access 2000 on my PC.
I copied it to a laptop which runs Access 2003 and XP.
I opened the database on the laptop and printed some reports, but the borders of all text boxes on the reports were then somehow reset to “solid”, while I had it “transparent” on the PC.

I changed it back to transparent and I’m not going to try to replicate it again; just wondered if anybody had the same problem. Maybe its got nothing to do with the copying. Maybe I reset something somewhere.
Thanx.
I have never heard of such a problem happening on its own, but if this anomaly still exists, this little code snippet may cure it:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Report_Open(Cancel As Integer)
  2. Dim ctl As Control
  3.  
  4. For Each ctl In Me.Controls
  5.   If ctl.ControlType = acTextBox Then
  6.     ctl.BorderStyle = 0     'Transparent
  7.   End If
  8. Next
  9. End Sub
P.S. Just for my own curiosity, let me know how you made out.
Mar 14 '07 #2

P: 23
Thanx I'll use it.
Mar 15 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.