Property Types (XP)

Topic

New Reply

the following code gets an error – invalid field data type
Set prpProperty = fldNewField.CreateProperty(“Caption”, dbChar, rstField!Field_Caption)
the VBA help is no help – dbChar was the only type I could find but its obviously not right.

Reply | Quote

Replies

I am not exactly sure what you’re doing, however I believe that if you try and add a “caption” to a table when you build a table with DAO (and I presume ADO), then you get an error. So my guess is that the “caption property” is something to do with MS Access and not available in DAO or ADO? However I could very well be barking up the wrong tree, in the wrong forest, and even on the wrong planet!

Cheers Tony.

Reply | Quote

I tried a couple of things and found that dbText worked instead of dbChar

Reply | Quote