Skip to content

x Want to participate? Join the group to interact
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 1 reply
  • Subscribers 110 subscribers
  • Views 1224 views
  • Users 0 members are here
Browse Forums
Announcements
312
topics
279
replies
Databases and Operating Systems
775
topics
3k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
771
topics
2k
replies
Reporting and Analytics
1k
topics
4k
replies
Reports, Macros, and Customizations
818
topics
3k
replies
Sage CRM for Sage 300
198
topics
434
replies
jmainland

Hide specific detail columns using VB/VBA

SOLVED
Posted By

I'm creating a customized OE Entry screen. I want all the users to have the exact same fields and detail columns. I'm able to hide fields on the header level using the code below. But I'm not sure how to hide specific detail columns. Anyone know how to do this?

Private Sub AccpacOE1100UICtrl1_OnUIAppOpened()
     'HIDE HISTORY BUTTON
     AccpacOE1100UICtrl1.UIAppControls("APP_History_Button").MacroVisibleFlag = False
End Sub

  • +1
    verified answer

    You're looking for the AccpacGrid control. Once you have that, there are options for accessing the properties of individual columns.  Here's a small sample that I have for locking down some columns in the taxes grid on the Order Entry screen:

        'TAX GRID
        Dim avlTaxes As AccpacGrid
        Dim i As Integer
        Set avlTaxes = AccpacUI.object.UIAppControls("agdOEORDHtax4").GetControl
        For i = 0 To avlTaxes.ColumnCount - 1
            Debug.Print CStr(i) & ":" & avlTaxes.GetColumnName(i)
        Next i
        avlTaxes.SetEditable 4, False

*Community Hub is the new name for Sage City