format fields into currency, percentage and Date

[Zandra]

Hi,
I have 3 fields in my table and would like to format them into currency, percentage and dates. Is there a way to do this using vba?
Field Names are as following:
Cost, Percentage and Date of Purchase

Table name is MyTable.

thanks for your help

 

[Rabbie]

Why not just change the formats in the Table design View?