Results 1 to 12 of 12
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Brookline, Massachusetts, USA
    Posts
    606
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Subform formats (2K, XP)

    I have a subform in datasheet view on a Main form. I want the column headings of the sf to be Bold, but I can find no way to change the font weight that works. The font appears to be Normal.
    All suggestions appreciated.
    Thanks,
    Howard

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

    Re: Subform formats (2K, XP)

    I'm afraid there is nothing you can do about it in datasheet view. If you want more control over the way the form look, make it into a continuous form. With a bit of work, you can make it look more or less like a datasheet while being able to set fonts, font weights for columns and column headers individually.

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

    Re: Subform formats (2K, XP)

    You should be able to change the font for the data too. Try opening the subform in design view directly from the database window, then setting the desired fonts.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Brookline, Massachusetts, USA
    Posts
    606
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Re: Subform formats (2K, XP)

    OK on the headings, but what about the data? I can make the data fields bold when I manipulate the subform (inside the Main form) in Design view, but when I switch the Main form view to Form View the font is still normal.
    Also, what does Tools/Options/Datasheet do for a living? There is a font weight option that seems to do nothing.
    Puzzled,
    Howard

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Brookline, Massachusetts, USA
    Posts
    606
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Re: Subform formats (2K, XP)

    I should, but I can't. The subform in design view (form) , from the db window, has the bold format. When I switch to datasheet view, it's normal.
    Did you see my related question on Tools/Options/Datasheet in the original post? I added that question after you had initiated your reply.
    Still puzzled,
    Howard

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

    Re: Subform formats (2K, XP)

    1. Tools | Options..., Datasheet has no effect on datasheets in which the font setting has been modified interactively, only on new datasheets and on existing ones that haven't been modified interactively.

    2. If you stick to datasheet view, setting font properties in design view is useless; the settings will be ignored. Open the main form (in form view), click in the subform (in datasheet view), and then set the font properties.

    3. My original suggestion was to use continuous form view instead of datasheet view. In a continuous form you can make one field bold, another one italic, etc. In a datasheet form, font changes apply to the datasheet as a whole.

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Brookline, Massachusetts, USA
    Posts
    606
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Re: Subform formats (2K, XP)

    Thanks for hanging in with me.
    Re item 2. I open the Main form in Form View and click on the subform, which is in datasheet view. I click on a field and check its properties. (Properties had been opened in design view.) Properties say Bold, but font is normal. Nothing I do will change the font weight.
    I avoided continuous form suggestion because I thought it would take too long to get right. Hah!
    Regards,
    Howard

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

    Re: Subform formats (2K, XP)

    There is NO connection between the font properties in the Properties window and what you see in datasheet view. You must use the Format | Font... menu option to set the font for the datasheet, and Format | Datasheet... to set background color, grid lines etc.

  9. #9
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Brookline, Massachusetts, USA
    Posts
    606
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Re: Subform formats (2K, XP)

    Hans, Thank you. It was clearly a case of right church, wrong pew for me. I will try the format/font when I get back to my office tomorrow.
    Howard

  10. #10
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Brookline, Massachusetts, USA
    Posts
    606
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Re: Subform formats (2K, XP)

    Hi Hans,
    Success. Thanks for fonting me in the right direction! The form is just the way I want it, except for the Normal column headings. I've been using Access for a long time and just never came across the need to format a datasheet.
    When I have some more time I'll experiment with your continuous form suggestion. I'm always willing to learn something new.
    Thanks again for your help.
    Howard

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

    Re: Subform formats (2K, XP)

    >> Thanks for fonting me
    Is that related to the "right church, wrong pew" from your previous reply? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  12. #12
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Brookline, Massachusetts, USA
    Posts
    606
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Re: Subform formats (2K, XP)

    Yeah, I'm an unreconstructed punster.
    Have a great weekend.
    Howard

Posting Permissions

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