The editor supports the following options:

• exEditRight, Right-aligns text in a single-line or multiline edit control.
• exEditPassword, Specifies a value that indicates whether an edit control displays all characters as an asterisk (*) as they are typed ( passwords ).
• exEditPasswordChar, Specifies a value that indicates the password character.
• exEditLimitText, Limits the length of the text that the user may enter into an edit control.
• exEditDecimalSymbol, Specifies the symbol that indicates the decimal values while editing a floating point number. The Numeric property should be on exFloat.
• exEditSelStart, Sets the starting point of text selected, when an EditType editor is opened.
• exEditSelLength, Sets the number of characters selected, when an EditType editor is opened.
• exEditLockedBackColor property. Specifies the background color for a locked edit control.
• exEditLockedForeColor property. Specifies the foreground color for a locked edit control.

It provides an intuitive interface for your users to select values from predefined lists presented in a drop-down window. The DropDownListType editor has no standard edit field associated. Use the AddItem or InsertItem method to add predefined values to the drop down list.  The DropDownRows property specifies the maximum number of visible rows into the drop-down list. The editor displays the caption of the item that matches the CellValue value. The item's icon is also displayed if it exists. 

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 editor supports the following options:

• exDropDownImage, displays the predefined icon in the control's cell, if the user selects an item from a drop down editor.
• exDropDownBackColor, specifies the drop down's background color
• exDropDownForeColor, specifies the drop down's foreground color
• exDropDownColumnCaption, specifies the HTML caption for each column within the drop down list, separated by ¦ character (vertical broken bar, ALT + 221)
• exDropDownColumnWidth, specifies the width for each column within the drop down list, separated by ¦ character (vertical broken bar, ALT + 221).
• exDropDownColumnPosition, specifies the position for each column within the drop down list, separated by ¦ character (vertical broken bar, ALT + 221). 
• exDropDownColumnAutoResize, specifies whether the drop down list resizes automatically its visible columns to fit the drop down width

The DateType is a date/calendar control ( not the Microsoft Calendar Control ). The dropdown calendar provides an efficient and appealing way to edit dates at runtime. The DateType editor has a standard edit control associated. The user can easy select a date by selecting a date from the drop down calendar, or by typing directly the date.  The editor displays the CellValue value as date. To change how the way how the control displays the date you can use FormatColumn event. The AddItem or InsertItem method has no effect, if the EditType is DateType. 

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

You can include a color selection control in your applications via the ColorType editor. Check the ColorListType also. The editor has a standard edit control and a color drop-down window. The color drop-down window contains two tabs that can be used to select colors, the "Pallette" tab shows a grid of colors, while the "System" tab shows the current windows color constants. The AddItem or InsertItem methodhas no effect, if the EditType is ColorType. You can use options like exColorShowPalette or exColorShowSystem.

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.  The AddItem or InsertItem method has no effect, if the EditType is PictureType. 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. 

Change the path if necessary, in the following sample:

' Creates an ADO Recordset
Dim rs As Object
Set rs = CreateObject("ADODB.Recordset")
rs.Open "Employees", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= D:\Program Files\Microsoft Visual Studio\VB98\NWIND.MDB", 3

' Adds a column of PictureType edit
Dim c As Column
Set c = .Columns.Add("OLEObject")
With c.Editor
.EditType = PictureType
End With
.Items.CellValue(.Items(0), "OLEObject") = rs("Photo").Value

You can include a color selection control in your application via the ColorListType editor, also. The editor hosts a predefined list of colors. By default. the following colors are added: Black, White, Dark Red, Dark Green, Dark Yellow, Dark Blue, Dark Magenta, Dark Cyan, Light Grey, Dark Grey, Red, Green, Yellow, Blue, Magenta, Cyan. The AddItem method adds a new color to your color list editor. You can use the exColorListShowName option to display the color's name.

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

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

For instance, if your cells load boolean values ( True is -1, False is 0 ), the control displays the partial-check icon for True values. You can call the following code before loading the CheckValueType editor:

Grid1.DefaultEditorOption(exCheckValue2) = 1 

in order to replace the partial-check appearance, to check state appearance.