The EditType editor provides the following configurable options:

• exEditAllowContextMenu, determines whether the editor displays the default context menu on right-click
• exEditAllowOverType, enables overtype mode in the editor
• exEditDecimalSymbol, sets the symbol used for decimal points when editing floating-point numbers. The Numeric property must be set to exFloat
• exEditLimitText, restricts the maximum number of characters the user can enter
• exEditLockedBackColor, sets the background color of a locked edit control
• exEditLockedForeColor, sets the foreground color of a locked edit control
• exEditOverType, indicates whether the editor is in insert or overtype mode
• exEditPassword, determines whether the edit control displays all characters as asterisks (*) for password input
• exEditPasswordChar, defines the character used for password masking
• exEditRight, aligns text to the right in single-line or multiline edit controls
• exEditSelLength, specifies the number of characters selected when the editor is opened
• exEditSelStart, specifies the starting position of the text selection when the editor is opened

The following sample adds a column with a DropDownListType editor:

With .Columns.Add("Editor").Editor
    .DropDownAutoWidth = False
    .EditType = DropDownListType
    .AddItem 0, "Single Bed", 1
    .AddItem 1, "Double Bed", 2
    .AddItem 2, "Apartments", 3
    .InsertItem 3, "1 Bed Apartment", 4, 2
    .InsertItem 4, "2 Bed Apartment", 5, 2
    .AddItem 5, "Suite", 4
    .InsertItem 6, "Royal Suite", 1, 5
    .InsertItem 7, "Deluxe Suite", 2, 5
    .ExpandAll
End With
.Items.CellValue(.Items(0), "Editor") = 3

The DropDownListType editor provides the following configurable options:

• exAutoDropDownList, automatically shows the drop-down list when the user starts typing
• exAutoSearch, specifies the kind of searching while the user types characters within the drop-down editor
• exDropDownBackColor, specifies the drop-down's background color
• exDropDownColumnAutoResize, specifies whether the drop-down list resizes its visible columns to fit the drop-down width
• exDropDownColumnCaption, specifies the HTML caption for each column within the drop-down list, separated by ¦ character
• exDropDownColumnPosition, specifies the position for each column within the drop-down list, separated by ¦ character
• exDropDownColumnWidth, specifies the width for each column within the drop-down list, separated by ¦ character
• exDropDownForeColor, specifies the drop-down's foreground color
• exDropDownImage, displays the predefined icon in the cell when the user selects an item from the drop-down
• exExpandOnSearch, expands items while the user types characters into the drop-down editor

The MemoType editor provides the following configurable options:

• exMemoAutoSize, specifies whether the MemoType editor resizes automatically when the user changes the text
• exMemoHScrollBar, adds a horizontal scroll bar to the MemoType editor
• exMemoVScrollBar, adds a vertical scroll bar to the MemoType editor

The DateType editor allows the following configurable options:

• exDateAllowNullDate, allows specifying an empty date
• exDateFirstWeekDay, specifies the first day of the week (0 = Sunday, 1 = Monday, ..., 6 = Saturday)
• exDateMarkToday, indicates whether the current date is marked
• exDateMonths, specifies the names of months separated by spaces
• exDateShowScroll, specifies whether the years scroll bar is visible
• exDateShowTodayButton, specifies whether the 'Today' button is visible
• exDateTodayCaption, specifies the caption for the 'Today' button
• exDateWeekDays, specifies shortcuts for weekdays, separated by spaces
• exDateWeeksHeader, specifies whether the weeks header is visible

The following sample adds a column with a DateType editor:

With .Columns.Add("Editor").Editor
    .EditType = DateType
End With
.Items.CellValue(.Items(0), "Editor") = Date

The ColorType editor allows the following configurable options:

• exColorShowPalette, specifies whether the palette colors list is displayed
• exColorShowSystem, specifies whether the system colors list is displayed

The following sample adds a column with a ColorType editor:

With .Columns.Add("Editor").Editor
    .EditType = ColorType
End With
.Items.CellValue(.Items(0), "Editor") = vbRed

The PictureType provides an elegant way for displaying the fields of OLE Object type and cells that have a reference to an IPicture interface. An OLE Object field can contain a picture, a Microsoft Clip Gallery, a package, a chart, PowerPoint slide, a word document, a WordPad document, a wave file, an so on. In MS Access you can specify the field type to OLE Object. The DropDownMinWidth property specifies the minimum width for the drop-down window. The drop-down window is scaled based on the picture size.  If your control is bounded to a ADO recordset, it automatically detects the OLE Object fields, so setting the editor's type to PictureType is not necessary.  If your control is not bounded to an ADO recordset you can use the following sample to view OLE objects in the column "OLEObject" ( the sample uses the NWIND database installed in your VB folder. The CellValue property can store a reference to an IPicture interface (returned by LoadPicture).

The PictureType editor allows the following configurable options:

• exShowPictureType, specifies whether the editor displays the type of the picture

The following sample shows how you can use the PictureType editor with a picture being loaded using the LoadPicture API:

With .Columns.Add("Editor").Editor
.EditType = PictureType
End With
.Items.CellValue(.Items(0), "OLEObject") = .ExecuteTemplate("LoadPicture(`" + App.Path + "\human.png" & "`)")

The AddItem or InsertItem method has no effect, if the EditType is PictureType. 

The ProgressBarType editor allows the following configurable options:

• exProgressBarAlignment, specifies the alignment of the caption inside the progress bar editor
• exProgressBarBackColor, specifies the background color of the progress bar editor
• exProgressBarMarkTicker, specifies whether the ticker or background of the progress bar is visible or hidden

The ColorListType editor provides the following configurable options:

• exColorListShowName, specifies whether the editor displays the name of the color
• exDropDownBackColor, specifies the drop down's background color
• exDropDownForeColor, specifies the drop down's foreground color

The following sample adds few custom colors to the ColorListType editor:

With .Columns.Add("Editor").Editor
    .EditType = ColorListType
    .AddItem 128, "Dark Red"
    .AddItem RGB(0, 128, 0), "Dark Green"
    .AddItem RGB(0, 0, 128), "Dark Blue"
End With
.Items.CellValue(.Items(0), "Editor") = 128

The CheckValueType editor supports the following options:

• exCheckValue0: Specifies the check box state displayed for the unchecked state.
• exCheckValue1: Specifies the check box state displayed for the checked state.
• exCheckValue2: Specifies the check box state displayed for the partial-check state.

For example, if your cells contain Boolean values (True is -1, False is 0), the control displays the partial-check icon for True values by default. You can override this behavior by executing the following code before assigning the CheckValueType editor:

G2antt1.DefaultEditorOption(exCheckValue2) = 1

This replaces the partial-check appearance with the checked-state appearance.

The CalculatorType editor provides the following configurable options:

• exCalcButtons, defines the buttons and their layout in the calculator editor
• exCalcButtonHeight, sets the height of the calculator buttons in pixels
• exCalcButtonWidth, sets the width of the calculator buttons in pixels
• exCalcCannotDivideByZero, specifies the message shown when division by zero occurs
• exCalcExecuteKeys, determines whether keys execute while the drop-down is hidden
• exCalcPictureDown, sets the picture for a button in the down state
• exCalcPictureUp, sets the picture for a button in the up state