ADOX+Access: how to set column formatting in Access from ADOX?

[Max]

Access columns do have a Format property allowing for example a single do be
shown with percentage style.
Is there any extended property that can be set from ADOX at column creation
to set Access format style? Can't find anything in standard ADOX
documentation. Thanks.

Example below => column MyColumn created as single but not formatted as
percent in Access

Sub CreateAccessTable()
Dim catDB As ADOX.Catalog
Dim tbl As ADOX.Table

Set catDB = New ADOX.Catalog
catDB.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\test.mdb;"

Set tbl = New ADOX.Table
With tbl
.Name = "TestTable"
With .Columns
.Append "MyColumn", adSingle
End With
End With

catDB.Tables.Append tbl
Set catDB = Nothing
End Sub

 

[Developer]

Is there any extended property that can be set from ADOX at column
creation

to set Access format style?

Unfortunatly there is not.

--
Mike Collier
www.adoanywhere.com

Access columns do have a Format property allowing for example a single do be
shown with percentage style.

Can't find anything in standard ADOX