Change field property in an existing table

  • Thread starter Thread starter hlam
  • Start date Start date
H

hlam

Can anyone show me how to change a field property in an existing table
using VBA? e.g. change field 3,4 and 5 to Double with 2 decimals. This
table is created from Pivot query. Thank you.
 
If it's something other than Double, your best bet is to add a new field
with the correct properties, run an update query that populates the new
field with values from the old field, delete the old field then rename the
new field. That's actually what Access does under the covers when you make
such a change through the GUI.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format changes 1
Problems With Precision while Linking Tables 4
Special characters 3
Decimal places in forms and tables 5
Auto number in an existing table 4
Access How to remove a non-existent field from a form's Field List 0
Wrap Text in Access Form Pivot table 0
Is there a way of not showing zero totals in a pivot table? 2

Back
Top