Change field property in an existing table

H

hlam

Can anyone show me how to change a field property in an existing table
using VBA? e.g. change field 3,4 and 5 to Double with 2 decimals. This
table is created from Pivot query. Thank you.
 
D

Douglas J. Steele

If it's something other than Double, your best bet is to add a new field
with the correct properties, run an update query that populates the new
field with values from the old field, delete the old field then rename the
new field. That's actually what Access does under the covers when you make
such a change through the GUI.
 
Top