Can't change font size on a subform displayed as datasheet

[BruceUK]

I have a main form displayed as a single record and a linked subform displayed as a datasheet. The controls in the subform are all text boxes except for one check box. Originally I set up all the text box controls with a font size of 11, but then decided to change them all to font size 10. The controls in the main form are being displayed correctly with the new font size of 10, but those in the subform are still being displayed at font size 11. Even when I display the subform independently, the font size is still at 11.



Can someone identify what the problem is?

In case this is relevant, I should mention that I'm using Access 365 but this particular application is an older one, which I've kept in the Access 2000 format with a .mdb extension.

Any ideas would be much appreciated!

[Bob Fitz]

What did you do to change to the smaller font

[moke123]

Did you try the datasheet settings in the backstage options?

[BruceUK]

What did you do to change to the smaller font

I displayed the subform in the design view, selected all the text boxes, right-clicked on one of them and selected 'Properties' from the drop-down menu, which displayed the Properties list. I selected the 'Font Size' attribute and changed the value from 11 to 10. I then re-saved the form definition.

Did I miss something?

[Missinglinq]

Using the Option setting like that is machine specific, I believe...i.e. all machines would have to be set the same...and it would apply to all Datasheet Forms in all Databases.

You can change the Display of a given Datasheet Form using something like this:

Private Sub Form_Load()
  Me.DatasheetFontHeight = 10
End Sub

Linq ;0)>

[BruceUK]

Did you try the datasheet settings in the backstage options?

I checked this out - the default font size is set to 11. However this is only a default value, governing the font size that will apply when controls are first created on a form. If the font size of particular controls is subsequently changed as I've done, then surely the new size should then apply?

[Bob Fitz]

I displayed the subform in the design view, selected all the text boxes, right-clicked on one of them and selected 'Properties' from the drop-down menu, which displayed the Properties list. I selected the 'Font Size' attribute and changed the value from 11 to 10. I then re-saved the form definition.

Did I miss something?

Not that I can think of.

If you make the changes. Close the form and then open again in design view, are the changes retained.

[BruceUK]

Not that I can think of.

If you make the changes. Close the form and then open again in design view, are the changes retained.

Yes they are retained.

[Bob Fitz]

And do they still display in the wrong size?

[moke123]

looks like code suggested by Ling is solution.

https://docs.microsoft.com/en-us/off...heetfontheight

[BruceUK]

And do they still display in the wrong size?

Yes.

The font being used is Calibri (Detail). This was the default font, and I haven't changed it but, as far as I know, there's no reason why it shouldn't be possible to use a font size of 10 with the Calibri (Detail) font.

[Missinglinq]

...If the font size of particular controls is subsequently changed as I've done, then surely the new size should then apply?

In Datasheet View the rules are all different...and that's simply the way it is!

In Datasheet View...you can set the Font Size for all Controls in all Datasheets in all Databases on each and every machine...or you can use the code I gave to set the Font Size for a given Datasheet on every machine using the Database.

Linq ;0)>

[BruceUK]

OK, I've used Linq's suggestion. For the 'On load' event for the subform, I've used the following statement:

Me.DatasheetFontHeight = 10

That has worked. But I'm still puzzled about why just changing the font size property for the various controls has no effect on how the datasheet is displayed.

Anyway, thanks for your suggestion Linq!

[Missinglinq]

...But I'm still puzzled about why just changing the font size property for the various controls has no effect on how the datasheet is displayed...

As I said...the rules for Datasheet Views are different! In Design View, for instance, you can add Command Buttons...but when you open the Form in Datasheet View...the buttons aren't there! Datasheets are simply different creatures from other Access Forms!

You have to understand that Datasheets are natively used to display Forms...Queries...and Tables! That makes them different from other Forms.

Glad we could help!

Linq ;0)>