Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Preventing Subdatasheet Symbol

Discussion in 'Information Technology' started by Dean, Nov 16, 2005.

  1. Dean

    Dean
    Expand Collapse
    Guest

    I have a form with several subforms. If the users change from form view to
    datasheet view, the '+' symbol shows up and clicking this displays the data
    from one of the subforms. How can I hide the '+' symbol when in datasheet
    view so that this functionality is not available. I'm using Access 2002.
    TIA
    Dean
     
  2. Loading...

    Similar Threads Forum Date
    Legal Bombay HC questions law preventing women to work in bars post 9.30 pm Breaking News Mar 30, 2010

  3. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "Dean" <deanl144@hotmail.com.nospam> wrote in message
    news:uigW1wg6FHA.3648@tk2msftngp13.phx.gbl
    > I have a form with several subforms. If the users change from form
    > view to datasheet view, the '+' symbol shows up and clicking this
    > displays the data from one of the subforms. How can I hide the '+'
    > symbol when in datasheet view so that this functionality is not
    > available. I'm using Access 2002. TIA


    For each such table, open the table in design view, bring up the
    property sheet for the table (not any of the individual fields), and
    change the Subdatasheet Name property to [None].

    I think Allen Browne has posted some code to loop through all tables and
    do this programmatically. You can probably find it by searching Google
    Groups, if you want to do that.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     

Share This Page