Type property (Field)
Returns the data type for a specified Field object. Read-only DataTypeEnum.
| DataTypeEnum | Value | Description |
|---|---|---|
| adBSTR |
8
|
String data type |
| adCurrency |
6
|
Currency data type |
| adDecimal |
14
|
Decimal data type |
| adInteger |
3
|
Integer data type |
Applies to
Objects: Field
Syntax
object.Type
Parameters
| Part | Description |
|---|---|
| object | Required. An expression that returns a Field object. |
Remarks
.gif)
To return the value assigned to a field, use the Value property of a Field object retrieved from a Recordset object.
Example
Sub GetFirstFieldType()
Dim objApp As New MapPoint.Application
Dim objDataSet As MapPoint.DataSet
Set objDataSet = objApp.OpenMap(objApp.Path & "\Samples\Sales.ptm").DataSets("SampleData")
'The type of the first field
MsgBox objDataSet.Fields(1).Type
End Sub