Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hide column in subform (Datasheet view) (2000)

    As the subject implies, I'm trying to hide a column in a subform displayed in datasheet view. I have the visible property set to 'No', yet the little @#$!% insists on showing up. It works for other subforms based off tables with similar structure, just not for this one....any ideas as to what I may be missing?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hide column in subform (Datasheet view) (2000)

    Setting the Visible property of a control to No only works in single or continuous forms. To hide a column in a datasheet form, either remove the control entirely, or open the form in datasheet view, click in the column and select Format | Hide Column, then save the form.

    BTW I almost never use a form in datasheet view; I use a continuous form made to look like a datasheet instead, because that gives me much more control over how the form behaves.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide column in subform (Datasheet view) (2000)

    Hans, thanks for the help, hiding the column in datasheet view and saving it worked. I would use a continuous form, but the info is only for display purposes....it's not really functional at all. Thanks again <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide column in subform (Datasheet view) (2000)

    Hi Hans

    <BTW I almost never use a form in datasheet view; I use a continuous form made to look like a datasheet instead, because that gives me much more control over how the form behaves.>

    Do you have a demo of this you can share?

    No hurry, at you convenience

    Thanks, John

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hide column in subform (Datasheet view) (2000)

    The database attached to <post#=382292>post 382292</post#> contains several examples of continuous forms looking more or less like datasheet forms.

  6. #6
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide column in subform (Datasheet view) (2000)

    Hans

    Nice demos.

    I was thinking more in terms of coding continuous forms to behave like datasheet forms in regards to sorting the columns, up/down arrow key navigation through records, etc.

    Any demos like this liking around?

    Thanks, John

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hide column in subform (Datasheet view) (2000)

    Users cannot resize columns or move them around in a continuous form - I see that as an advantage rather than a disadvantage. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Navigation: see <post#=149385>post 149385</post#>

    Also see the threads starting at <post#=160156>post 160156</post#> and <post#=207986>post 207986</post#> for code examples.

  8. #8
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide column in subform (Datasheet view) (2000)

    Hans

    Links were very helpful

    Thanks, John

Posting Permissions

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