I came across an interesting problem the other day, and I thought I would share the solution.  I have a software that is publicly sold, that uses a VB.NET front end with an access back end.   I realize that I need to make an update, and that part of this update needs to involve me changing the field properties for a specific field.  Changing from an integer to a double is no problem, but I needed to change the 'Format' for the field from NULL to a percent.  There are no SQL commands that can do this as one might think.  UPDATE Table Update Column will allow you to change from int to double,