Datasheet Font

[JamesJ]

In Access Options one can set the Datasheet font. This applies
to new forms with a datasheet and not existing Datasheets.
Any way to set the font on existing Datasheets?
I'm using AC 2007 with split forms.

Thanks,
James

 

[Linq Adams via AccessMonster.com]

I don't run 2007, but a datatsheet form is pretty simple and quick to create
in other versions. You use the forms wizard, assign the fields you want, and
the form is created. Can't you change the Datasheet font to your choice in
Options, then use the wizard to recreate the datasheet forms? You're talking
about less than a minute a form.

 

[JamesJ]

There is much code in my split forms (the little I do). It would take
a while to recreate. Unless there's some code I can run at runtime.

James

 

[fredg]

In Access Options one can set the Datasheet font. This applies
to new forms with a datasheet and not existing Datasheets.
Any way to set the font on existing Datasheets?
I'm using AC 2007 with split forms.

Thanks,
James

Open the form (in Datasheet View).
Select any cell.
Click on Format + Font

You can change the Fontname , fontsize, fontcolor, etc.

Any change affects the entire datasheet, not just that one cell.

 

[JamesJ]

Opening a form in datasheet view doesn't exist in AC 2007.
Only Design and Layout.
I did find a form's DataSheetFontName Property that seems to work.

James

 

[Linq Adams via AccessMonster.com]

I've been trolling thru the 5 forums I frequent looking for this thread again
because I just came on this elsewhere:

Private Sub Form_Open(Cancel As Integer)
Me.DatasheetFontName = "Arial"
End Sub

Just make sure you replace the "Arial" with a valid font name that you have
available. And remember, if this app is distributed, the other PCs have to
have it available also, or Access will revert to the default for that machine,
which could have some untoward effects.