Can anyone tell me how I programmatically set the the 'Format' and 'Decimal Places' properties when trying to create the TableDef object.
I can creat the object then set the other properties using the fields collect, e.g. tdf.Fields(0).DefaultValue, but cannot see any option for setting the format or decimal places.
Using Access 97
Thanks for any assistance
I can creat the object then set the other properties using the fields collect, e.g. tdf.Fields(0).DefaultValue, but cannot see any option for setting the format or decimal places.
Using Access 97
Thanks for any assistance