Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Mon Sep 22 14:27:22 CDT 2008
Dear List: I am trying to change the type of a field 'StartBase' in table 'MatterActions' from Number to Boolean. I've tried two approaches: 1) dbs.Execute "ALTER TABLE [MatterActions] ALTER Column StartBase Boolean" givers the error 3381 There is no field named 'Boolean' in table 'MatterActions' 2) Set tdf = dbs.TableDefs("MatterActions") tdf.Fields("StartBase").Type = dbBoolean gives the error invalid operation on the second line. Does anyone know the correct code to change this field's type? MTIA Rocky