Microsoft Access Extension Pack

The Microsoft Access Extension Pack contains a set of datatypes that correspond to data types available within Microsoft Access. Note that you can successfully use the standard TerraForm datatypes with Access, but these may prove useful. If a field in your database uses the Access Byte data type, for example, you can simply specify acByte as the datatype within a field of your form and be sure that TerraForm will make sure that only Byte-size data gets by! All the datatypes in this Pack are prefixed with "ac" to avoid conflicting with predefined datatypes and datatypes from other packs.

To use this datatype pack, open customtags/terraform/settings.cfm and find section 5. Remove the comment tags from the following line:

<!--- <cfinclude template="datatypes/msaccess.cfm"> --->

Examples

<cf_terrafield
  name="acByte"
  datatype="acByte"
/>

<cf_terrafield
  name="acCurrency"
  datatype="acCurrency"
/>

<cf_terrafield
  name="acDateTime"
  datatype="acDateTime"
/>

<cf_terrafield
  name="acDecimal"
  datatype="acDecimal"
/>

<cf_terrafield
  name="acDouble"
  datatype="acDouble"
/>

<cf_terrafield
  name="acInteger"
  datatype="acInteger"
/>

<cf_terrafield
  name="acLongInteger"
  datatype="acLongInteger"
/>

<cf_terrafield
  name="acMemo"
  datatype="acMemo"
/>

<cf_terrafield
  name="acNumber"
  datatype="acNumber"
/>

<cf_terrafield
  name="acSingle"
  datatype="acSingle"
/>

<cf_terrafield
  name="acText"
  datatype="acText"
/>

<cf_terrafield
  name="acYesNo"
  datatype="acYesNo"
/>