Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Oct 2003
    Location
    Ontario, Canada
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Format SubDatasheet (Access 2000)

    I have a tabbed subdatasheet in datasheet view. It shows up as font 10 pt, I would like to reduce it. How?

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

    Re: Format SubDatasheet (Access 2000)

    My general advice would be to avoid subdatasheets, but won't Format | Font... work (while the focus is in the subdatasheet)?

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

    Re: Format SubDatasheet (Access 2000)

    What exactly do you mean by a "tabbed subdatasheet"? Access has tab controls and it has subdatasheets, but it has no mixture of the two. Do you by any chance mean that you have a tab control with subforms displayed as datasheets?
    Charlotte

  4. #4
    New Lounger
    Join Date
    Oct 2003
    Location
    Ontario, Canada
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format SubDatasheet (Access 2000)

    Yes, I have a tabbed form with a subdatasheet on it. I have reduced the font in the underlying table but the datasheet view font in the subdatasheet does not reduce. In fact, the properties doesn't list a font size. Thx for your response.

  5. #5
    New Lounger
    Join Date
    Oct 2003
    Location
    Ontario, Canada
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format SubDatasheet (Access 2000)

    Unfortunately, there is no Format/Font available. I am taking the underlying info straight from a table, which I have formatted to a smaller font, but it doesn't come through to the datasheet view in the subdatasheet. Thx for your response.

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

    Re: Format SubDatasheet (Access 2000)

    Have you disabled standard menus in Tools | Startup...? My Format menu displays a Font item while the focus is in the subdatasheet.
    Attached Images Attached Images
    • File Type: png x.png (18.1 KB, 0 views)

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Format SubDatasheet (Access 2000)

    Hello, Hans: Your responses in this thread have been very helpful. For quite some time I've tried to change the font size in a subdatasheet via the Format tab in Design View...to no avail, of course. It never once occurred to me that I could use Format > Font in Form View. <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

    I have to ask why you say, "My general advice would be to avoid subdatasheets." Really? What do you recommend one use instead? (And why?)

    As always, thank you for your help!

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

    Re: Format SubDatasheet (Access 2000)

    Subdatasheets in tables have a negative impact on performance. I always set the SubDatasheets property of tables to [None].

    I (almost) never use forms in datasheet view, and hence no subdatasheets in forms. The end user can mess up too much. Being a control freak, I don't like that <img src=/S/grin.gif border=0 alt=grin width=15 height=15>.

Posting Permissions

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