Form containing a Table; increasing the Table font size.

[GordonT]

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?

[June7]

Did you try changing the FontSize property of the combobox?

[GordonT]

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.

[June7]

Consider Continuous View and arrange the controls to appear much like Datasheet.

[GordonT]

Your Continuous View suggestion works, not quite what I wanted but a very satisfactory alternative. Thank you very much.

[Missinglinq]

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:

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:

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)>