Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Hide query field (2000/XP)

    I have a colleague who wants to hide the field headings in a query. ( Don't ask me why). I have never come across this question before... is it possible? See graphic below ( ie get rid of Ship name and Ship Address etc):
    Jerry

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hide query field (2000/XP)

    The simplest thing would be to create a report and not use column headings on the report. It seems counterproductive to me to just ist information without an indication of what it means, but that would be the way to do it. Queries, by their nature, use column headings.
    Charlotte

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hide query field (2000/XP)

    Thanks Charlotte

    That was similar to what I was suggesting, I thought another way was just do a straight export to excel and delete the headers. My colleague is in the dark on this one as well but it appears that one of our big brother governmental departments here is collating all this data from various areas and wanted us to strip out the field names so that they could put their own ones in <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15> <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15> <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15>
    Jerry

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hide query field (2000/XP)

    Both DoCmd.TransferText and DoCmd.TransferSpreadsheet have a HasFieldNames argument that will allow you to suppress field names in an export.
    Charlotte

Posting Permissions

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