How to get a field size of a field in a table?

[neemi]

If I have set a field in a table to Field size 50. How can I use code to check what the field size is?

I have tried something like...

Table!TableName!FieldName.FieldSize

But can't get it to work?

Does anyone have any ideas?

 

[KenReay]

Hi

Public Sub a()
Dim Db As DAO.Database
Dim tdf As DAO.TableDef
Dim fld As DAO.Field
'
Set Db = CurrentDb()
Set tdf = Db.TableDefs("FA1")
Set fld = tdf.Fields("FORMULA_NO")
Debug.Print fld.Size

End Sub

You will need a reference to the DAO library to use this code

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[ZmrAbdulla]

Another simple option is

MsgBox CurrentDb.TableDefs("TableName").Fields("FieldName").Size

________________________________________________________________________
Zameer Abdulla
Visit Me
No two children are alike - particularly if one is yours and the other isn't.