Navigation:  DAO Object Classes > DaoField Class >

DaoField:Size Access/Assign

Previous pageReturn to chapter overviewNext page

Purpose

A long value that is the maximum size of the field

 

Remarks

 

When you create a Field object with a data type other than Text, the Type property setting automatically determines the Size property setting; you don't need to set it. For a Field object with the Text data type, however, you can set Size to any integer up to the maximum text size (255 for Microsoft Jet databases). If you do not set the size, the field will be as large as the database allows.

For Long Binary and Memo Field objects, Size is always set to 0. Use the FieldSize method of the Field object to determine the size of the data in a specific record. The maximum size of a Long Binary or Memo field is limited only by your system resources or the maximum size that the database allows

 

Class

DaoField

 

Example

Fields Sample