

To create a new Field object in an Index, TableDef, or Relation object, use the CreateField method.

Use the DefaultValue property of a field on a TableDef object to set the default value for this field when new records are added. Use the AllowZeroLength, DefaultValue, Required, ValidateOnSet, ValidationRule, or ValidationText properties to set or return validation conditions. Use the ForeignName property to set or return information about a foreign field in a Relation object. Use the SourceField and SourceTable properties to determine the original source of the data.

Use the Type, Size, and Attributes properties to determine the type of data that can be stored in the field. Use the AppendChunk and GetChunk methods and the FieldSize property to get or set a value in an OLE Object or Memo field of a Recordset object. Use the Value property of a field in a Recordset object to set or return stored data. Use the OrdinalPosition property to set or return the presentation order of the Field object in a Fields collection. In a Microsoft Access workspacee, you manipulate a field using a Field object and its methods and properties. You use the Field objects in a Recordset object to read and set values for the fields in the current record of the Recordset object. The Fields collection of a Recordset object represents the Field objects in a row of data, or in a record. The Fields collections of Index, QueryDef, Relation, and TableDef objects contain the specifications for the fields those objects represent. Records show than L&M opened its first Indian office and showroom in Calcutta in the year 1877.A Field object represents a column of data with a common data type and a common set of properties. Not much information is available on the early history of the company, but its reputation as a chain of High grade Opticians and makers of best quality Survey, Scientific and Meteorological Instruments was well known. The two families set up operations all over the world including London, Cairo, Spain, Portugal, Indian subcontinent, Colombo, Rangoon and Singapore. Ltd., traces its roots to two London based Jewish families, that of Lawrence and Mayo. Looking back in to the history, it will be interesting to know how Human effort of several generations has built and nurtured this company through 135+ years of its marvelous existence. Year 2002 will be a memorable landmark in the long and honorable history of this corporate entity as it will celebrate its post century silver jubilee during this year. Ltd., one of the living centurions in the Corporate World, needs no introduction to the Public in India. Import Export Code (IEC) 03881***** Lawrence & Mayo India Pvt.
