FieldLen

Method
Retrieves the declared length of a specified field.

Category
Fields

 

Syntax
Function FieldLen(ByVal hTable As Long, ByVal FieldNo As Long) As Short

hTable
The handle to the table.

FieldNo
The number of the field whose length is to be retrieved.

 

Comments
FieldLen returns the declared length of FieldNo. If FieldNo does not exist, the function will raise an exception.

While FieldLen returns the declared length, FieldSize returns the actual length of the data in a field. A text field could, for example, be declared with length 30, while the actual size of the data in the field is 8 bytes.

For more information about C/SIDE field types and their sizes, see the Application Designer’s Guide.



© 2009 Microsoft Corporation. All rights reserved.