Hi,
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.
Sounds like you haven't designed your table with the correct data types for the fields.
Correct this, and the data will display correctly with the default format of your Windows.
/gustav
0
karinos57Author Commented:
gustav,
I am importing excel files into my database using vba. so i lose the format i setup for the table everytime i import them. this is big project i am working on now and i am trying to automate everthing. thanks.
CVDate accepts Null. Or use Nz to replace Null with default values:
Select
CVDate([YourDateField]) AS YourDate,
CCur(Nz([YourCurrencyField
<.. etc.>
From
tblYourImportTable
/gustav