Getting column widths from MSysObjects using SQL

EarthSea 

If VBA is an option for you, you could get the column width with a function (that also can be used in a query):

Public Function GetColumnWidth(sTable As String, sFieldname As String) As Long
  Dim rs As dao.Recordset
  Set rs = CurrentDb.OpenRecordset(sTable)
  
  GetColumnWidth = -1 'Init the return value in case the requested field is not found
  
  Dim Field As dao.Field
  rs.MoveFirst
  'Loop over the table fields until the requested field is found
  For Each Field In rs.Fields
    If Field.Name = sFieldname Then
      GetColumnWidth = Field.Size
      Exit For 'Step out of the For-loop since the requested field is found
    End If
  Next
  Set rs = Nothing
End Function

Place this function in a module and you can call it from a regular Access-query:

SELECT GetColumnWidth("tblBusiness", "BusinessId") AS ColumnWidth

Where "tblBusiness" is the table name and "BusinessID" is the field name, which can be replaced with any table and field name you like.

Maybe this works for you.

Best regards,

Tieme