Alter Table to Change or Clear column format

[JustJosh478]

I have created this statement to change a column from date/time to number and it works...

ALTER TABLE [Supplier Workbook] ALTER COLUMN [Total Time Spent] Number

but it's keeping the format of "h:nn:ss". Is there a way to add a statement to my query to clear or change the formatting to General or blank?

 

[dhookom]

I think you would need some DAO code to change the format property of the field.

Currentdb.TableDefs("Supplier Workbook").Fields("Total Time Spent").Properties("Format")="Fixed"

Duane
Hook'D on Access
MS Access MVP