CreateFieldMethod

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top