Report text box borders automatically reset to solid

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Gerhard
    New Member
    • Feb 2007
    • 23

    Report text box borders automatically reset to solid

    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.
  • ADezii
    Recognized Expert Expert
    • Apr 2006
    • 8834

    #2
    Originally posted by Gerhard
    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:
    Code:
    [B]Private Sub Report_Open(Cancel As Integer)[/B]
    Dim ctl As Control
    
    For Each ctl In Me.Controls
      If ctl.ControlType = acTextBox Then
        ctl.BorderStyle = 0     'Transparent
      End If
    Next
    [B]End Sub[/B]
    P.S. Just for my own curiosity, let me know how you made out.

    Comment

    • Gerhard
      New Member
      • Feb 2007
      • 23

      #3
      Thanx I'll use it.

      Comment

      Working...