# of fields in Access 2003 table

[szhang1988]

Hi, I'm really realy new to MS Access. I try to find out how many fields in a table. is there a way to do that?

Thanks a bunch in advance.

 

[lespaul]

you mean in an existing table?

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com

 

[szhang1988]

yes, Leslie. The existing table was populated from a csv file.

 

[MajP]

if the table is in the current db then.

Public Function getFieldCount(strTblName As String) As Integer
  getFieldCount = CurrentDb.OpenRecordset(strTblName).Fields.count
End Function

 

[szhang1988]

Thanks much, majP. Beside this VBA, does MS Access have a built-in feature that provides the field count?