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.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<(E-Mail Removed)> wrote in message
news:1964301c44cce$98ea1c70$(E-Mail Removed)...
> 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.
