By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,271 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

field types

P: n/a
hi there everyone

when using for example
..Fields.Append .CreateField("GeoType", dbText, 30)

does anyone know where to get a list of the possible field types?
the only ones I know of are dbText, dbLong
thanks ;)
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Open a code window.
Press F2 to open the Object Browser.
Choose the DAO library, and search for DataTypeEnum.

In the Access 2003 help file, the constants are also listed under
CreateField.

For translating the value back to English (the Access field type name), see
the FieldTypeNams() function at:
http://allenbrowne.com/func-06.html

--
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.

"Michael" <we****@hotmail.com> wrote in message
news:af*************************@posting.google.co m...

when using for example
.Fields.Append .CreateField("GeoType", dbText, 30)

does anyone know where to get a list of the possible field types?
the only ones I know of are dbText, dbLong

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.