Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Property Types (XP)

    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.

  2. #2
    New Lounger
    Join Date
    Sep 2006
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Property Types (XP)

    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.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Property Types (XP)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •