Field Length 1

[nicsin]

Hi all,

is it possible to read the length of a field in access using sql (JET)?

Thanx,
Niko

 

[SQLBI]

Hi,

SELECT LEN([Field Name])
FROM [Your Table]
WHERE...

Hope this helps.

Cheers,
Leigh

You're only as good as your last backup!

 

[nicsin]

thank you for the reply Leigh but probably I wasn't clear enough.

I am looking for the length of the field in the database. like what is the maximum number of characters a text field can have.

 

[SQLBI]

Ahh, sorry.

Cheers,
Leigh

You're only as good as your last backup!

 

[Golom]

Using SQL ... No.

Using JET DAO ... Yes

Currentdb.TableDefs("myTable").Fields("myField").Size

 

[nicsin]

Yeah that's right! Well just came back to say that it's possible with ADO as well (i am using ADO) using the recordset's field's attribute DefinedSize (ActualSize is also available)

Great