Column Display

Public Function DisplayCols_BaseColIndex(ColIndex As Integer) As Integer

Returns the index of the column in the underlying DataList that is linked to the passed display column index.


Property Get DisplayCols_ColCount() As Integer

The number of columns displayed.


Public Function DisplayCols_ColIndexFromColName(FieldName As String, Optional FlagError As Boolean = False) As Integer

Returns the display index of the named column. If the column name is not found, then the index -1 is returned and optionally an error is displayed.

Public Function DisplayCols_ColumnHeading(ColIndex As Integer) As Variant

Returns the column heading for the passed display column index.


Public Function DisplayCols_ColumnName(ColIndex As Integer, Optional WithSquareBrackets As Boolean = False) As Variant

Returns the column name for the passed display column index.


Public Sub DisplayCols_PrintDisplayColIndexes()

Print debugging information about the display columns.
The base DataList column index is displayed in brackets after the display column index.

Public Sub DisplayCols_SetDefaultColDisplayToListbox(lb As Access.ListBox)

Sets up display settings to mirror the column width settings in the listbox. Zero width columns are not displayed and columns beyond the end of the defined list are not displayed.
If using with a selection list, USE AFTER SETTING SELECTION MODE, since there is one additional column in a select box

Public Sub DisplayCols_SetupColumns(ColNames As String)

Define the display settings by passing a list of column names and optional aliases. Column indexes cannot be used in place of the name.


Public Sub DisplayCols_SetupHideRepeatColumns(ColNames As String, HideRepeatKeyColName As String)

Allows one or more column values to be displayed as empty on the second and subsequent occurence (ie. repeats) of a row value in a specified column. This allows similar behaviour to the 'hide duplicates' funtion in MS Access reports.

Private Sub SetDefaultColDisplay()

Sets up display settings to display all columns in the same order as the underlying list and not hide repeat values.