Is there a way to format fields into currency, percentage and dates using vba? I have a table that have 3 fields:
Cost, Percentage and Date of Purchase.
right now, those fields are showing just numbers but i would like to format them as mentioned above. Table name is called MainTable. thanks for the help.