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

Cheers

Dave

 

[Mile-O-Phile]

Some examples:

MyField = Format(MyField, "Currency")

MyField = Format(MyField, "£0.00"