Setting General Number Format in vba

I am appending some new fields to a table in vba and when I append a number
field with is a byte, it does not inherit any format. I want it to be the
General Number format, but it is blank. I have tried to change the format
with the following code, but it does not work. What is wrong with this code
and how can I make that byte number field have the General Number format?

Call
SetPropertyDAO(DBEngine(0)(0).TableDefs("tblCommendations").Fields("Year"),
"Format", dbByte, "General Number")

dixie


.

Relevant Pages

  • Storing different date formats in same field
    ... For sorting purposes, I would like to sort the ... YYYY/MM and YYYY/MM/DD ... then appending the table that has dates in the second format ...
    (microsoft.public.access.modulesdaovba)
  • Re: Joining multiple tables
    ... I am appending to the email because the format got tangled ... I am looking for help on building a query which joins about 3 ... Table 3: Product Mapping ...
    (comp.databases.oracle.server)
  • Re: Help with a SQL Query
    ... I am appending to the email because the format got tangled ... I am looking for help on building a query which joins about 3 ... Table 3: Product Mapping ...
    (comp.databases.oracle.misc)
  • Re: Format Painter APPENDS Conditional Formatting
    ... Microsoft Excel MVP ... When I use Format Painter, it is appending conditional formatting rules ...
    (microsoft.public.excel)
  • Re: Mail Merge Not Merging Data
    ... the data is in this format: ... Word's built-in MailMerge will only work with up to 255 fields if they come from certain types of data source - for example, 255 is the maximum number of columns Word can use from any Jet data source. ... In the VBA Editor, you can use View-Toolbars to enable the Debug menu. ...
    (microsoft.public.word.vba.general)
Loading