Formatting Fields in a Table Using Access VBA

[Daveswanton77]

I am trying to format a field in a table which is created from a query. The field needs to be formatted as currency as an update query is used to enter monetary amounts from another table. At present when I run the update query the amounts change to whole numbers and not currency amounts.

If I change the properties of the field manually before running the update its fine, but it needs to be done automatically within code before running the update.

Is there any way to do this using VB.

Thanks in Advance

 

[Pat Hartman]

Access uses the datatypes of the first n values in a column to determine the datatype of the new table field. Apparently, yours are integers. If you specifically format the field as currency in the query, that should carry through.