Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Sub AllowZeroLenghtonAllFields()
Dim db As Database
Dim tbl As TableDef
Dim fld As DAO.Field
Dim ballowzerolength As Boolean
Set db = CurrentDb
ballowzerolength = True
For Each tbl In db.TableDefs
With tbl
Debug.Print tbl.Name
If .Attributes = 0 Then 'only non system tables
For Each fld In .Fields
Debug.Print fld.Name
With fld
If .Type = dbText Or .Type = dbMemo Then
If .AllowZeroLength <> ballowzerolength Then
.AllowZeroLength = ballowzerolength
End If
End If
End With
Next
End If
End With
Next
End Sub