No Option for Font Name in Options>Default font

[JamesJoey]

Some time I like to change the font name of my split form datasheets.
I thought I found an easy wat by selecting 'Options'>'Datasheet'>'Default font'
But I find there is no option for the font name, only Size, Weight, Underline and Italic.

Currently I'm changing the font by using:

Public Function DataSheetFont(frm As Form)

    frm.DatasheetFontName = "Calibri"
    frm.DatasheetFontHeight = 12
    frm.DatasheetFontWeight = 400
    
End Function

But the code only changes the font name if I open the form and press ctl-s and then close and reopen the form.

Any ideas?
James

 

[isladogs]

I may be wrong but I don't think you can change the font for a standard split form whilst its open.

The easiest solution would be to create a simulated split form using a single form and a datasheet subform
When you click anywhere on the datasheet subform, the Form Datasheet ribbon is shown

For more details, see my article:

Build Your Own Split form

The Access split form has several important limitations. This article shows how you can create your own simulated split form which doesn't have the restrictions inherent with the built-in Access split form

isladogs.co.uk

 

[JamesJoey]

I used the wizard to create the main form and the datasheet subform.
But the datasheet subform only returns 1 record.
The wizard used the ID field in the Link Master Fields and Link Child Fields.

 

[isladogs]

Yes it would do that as the main form only shows one record at a time so that would also be true for the subform.
Study my example app. No link between master and child fields. Code is used to keep the main form & subform synchronised.