OK - you can parse through the recordset fields to find the datatype then format the cell as required. According to the suppliers you can change properties, but doesn't say whether one of those properties is a datatype, you will need to contact the suppliers or research their specification/help pages
air code would be something like
Code:
dim fld
for each fld in myRecordset.fields
select case fld.type
case dbBoolean
'do something here
case dbChar
'do something here
case....
end select
next fld
where myRecordset is the name of the recordset you assigned to the grid
for field types - depends on your type of recordset
dao - see this link https://docs.microsoft.com/en-us/off...e-property-dao
ado - https://docs.microsoft.com/en-us/sql...ql-server-2017