Field "Captions" in Access

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default Re: Field "Captions" in Access

    Phillip Windell wrote:
    > Is there a way to display the Caption of a Field in Access? I' like
    > to use them as column headings instead of using the Field's "Name".
    > This way I could have more meaningful column headings.
    >
    > I've tried the equivalent of <%=Rs.Fields(1).Caption %>
    > instead of the previous <%=Rs.Fields(1).Name %>
    > but it doesn't work.
    Sorry, but Caption is an Access-defined property that is not accessible via
    JetSQL.

    Bob Barrows


    Bob Barrows Guest

  2. Similar Questions and Discussions

    1. "Page" and "Rect" props of the Field prop in Javascript API
      Page property of the Field property in Javascript Acrobat API returns an array of pages that this field exists in. On the other hand, "rect" property...
    2. Compare 2 fields & delete everything in "field 2" that occurs in "field 1"
      Is it possible to compare 2 fields and delete everything in "field 2" that also occurs in "field 1" ? FIELD1 800-555-1212 for...
    3. Request.Form("Field Name") Versus Request.QueryString("Field Name")
      I want to know what's the differences between Request.Form("Field Name") and Request.QueryString("Field Name") OR they function exactly the...
    4. dr("field").toString returns "400.0000" instead of "400"
      I have just installed VS.NET 2003 on my computer. I have a project that I have been developing on VS.NET 2002. I haven't upgraded this project to...
    5. Retrieve "value list" in Access combo field via ASP?
      Is it possible to read the "value list" of a FIELD inside an Access database. I am considering typing in a value list for a particular field to...
  3. #2

    Default Re: Field "Captions" in Access

    Ok, Thanks Bob.

    "Bob Barrows" <reb_01501@yahoo.com> wrote in message
    news:#YDuqjuUDHA.2040@TK2MSFTNGP11.phx.gbl...
    > Phillip Windell wrote:
    > > Is there a way to display the Caption of a Field in Access? I'
    like
    > > to use them as column headings instead of using the Field's
    "Name".
    > > This way I could have more meaningful column headings.
    > >
    > > I've tried the equivalent of <%=Rs.Fields(1).Caption %>
    > > instead of the previous <%=Rs.Fields(1).Name %>
    > > but it doesn't work.
    >
    > Sorry, but Caption is an Access-defined property that is not
    accessible via
    > JetSQL.
    >
    > Bob Barrows
    >
    >

    Phillip Windell Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139