CreateFieldMethod

G

Guest

Is their a way to append a new Decimal field to an
existing table and specify its decimal places?
when I use dbDecimal it returns an error "Invalid Data
Type".
If not is their a way to ge the built in table design tool
onto a form.
Thanks.
 
A

Allen Browne

The Decimal field type was introduced 3 versions ago, and to my knowledge
Microsoft has not updated DAO to support this field type yet.

Seriously, this no great loss, as the Decimal field type does not even work
correctly:
http://allenbrowne.com/bug-08.html

If you are determined to do it anyway, you can use a DDL query statement
executed under ADO to create a field of type DECIMAL, with the precision and
scale specified in brackets. Alternatively use ADOX to create a column of
type acNumeric.
 

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

Excel does not accept text format! 0
Adding data to MS Access from csv file 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Create New Field Type=dbDecimal 2
Create Properties for Decimal and Date fields 1
Programmatically Modify Pivot Table Fields? 1
Change Precision and Scale 2
How do I clear a form? 0

Top