Create new field

[abenitez77]

I tried creating a new field using variables like this:

nFldType = "dbText"
nFldSize = "20"

tdf.Fields.Append tdf.CreateField(TblCol, nFldType, nFldSize)

But it does not like "dbText", when I use this it works:
tdf.Fields.Append tdf.CreateField(TblCol, dbText, nFldSize)

How can i get it to work with a variable in place? I have it in a function where it loops and creates decimal, text, currency, etc....

 

[James Deckert]

what happens if you do this?
nFldType = dbText
nFldSize = 20

I can't see how you defined your fields, but the field size should be an integer, not a string, so I removed the quotes.

 

[Ranman256]

why are you doing this in code?
just design the table and add the field.

 

[abenitez77]

thanks! this was the answer