Createefield code help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to use VBA code to create a field (OdEnd) as double with one decimal
place in table Stats. I cannot figure out the entire syntax. Can someone help
me?
 
Wylie said:
I want to use VBA code to create a field (OdEnd) as double with one decimal
place in table Stats. I cannot figure out the entire syntax.
Click to expand...


Here's one way:

CurrentDb.Execute "ALTER TABLE Stats " _
& "ADD COLUMN OdEnd DOUBLE"

The number of decimal places is not an inherant attribute of
a table field, it's a display/formatting thing that should
be dealt with in a form/report text box.
 
Back
Top