Results 1 to 6 of 6
  1. #1
    GordonT is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Location
    Lincolnshire
    Posts
    12

    Form containing a Table; increasing the Table font size.


    I have a Form which in a Combo Box displays one Field of a Table in database view. I would like to make the displayed Field font larger. Changing the font size in Access Options alters the font size in all Tables but does not change the size in the Field displayed on the form. Is it possible, please?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Did you try changing the FontSize property of the combobox?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    GordonT is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Location
    Lincolnshire
    Posts
    12
    That was the first thing I tried, it makes no difference when the Form Properties Default View = Datasheet. When the combobox is set to display only single records I can indeed determine the size of the displayed font.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Consider Continuous View and arrange the controls to appear much like Datasheet.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    GordonT is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Location
    Lincolnshire
    Posts
    12
    Your Continuous View suggestion works, not quite what I wanted but a very satisfactory alternative. Thank you very much.

  6. #6
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    It takes some work, depending on the number of Controls involved, but a Continuous View Form can be tweaked to look like a Datasheet View Form.

    FYI, if you wanted to change the Font Size of all Controls, in a given Datasheet View Form, leaving all other Datasheet View Forms set to the default, you can use code like this, in the particular Form:

    Code:
    Private Sub Form_Load()
       Me.DatasheetFontHeight = 16
    End Sub

    When I had a couple of vision impaired users in a situation where they never used the same PC from day to day (don't ask!) and so couldn't have their machines set up for their disability, I used this code in the Double-Click event of one or more of the Textboxes, to simply toggle the size:

    Code:
    Private Sub TextboxName_DblClick(Cancel As Integer)
      If Me.DatasheetFontHeight = 11 Then
       Me.DatasheetFontHeight = 16
      Else
       Me.DatasheetFontHeight = 11
      End If
    End Sub


    Linq ;0)>

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 07-25-2013, 07:20 AM
  2. Replies: 2
    Last Post: 03-20-2013, 04:25 PM
  3. Changing Font Color and Size in table
    By FormerJarHead in forum Access
    Replies: 2
    Last Post: 01-09-2013, 01:04 PM
  4. MsgBox font size
    By GraeagleBill in forum Programming
    Replies: 4
    Last Post: 01-02-2013, 02:59 PM
  5. Font Size control
    By techexpressinc in forum Forms
    Replies: 2
    Last Post: 06-29-2011, 06:26 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums