Dear members,
Does anyone know if thereīs a way to change the layout of a datasheet form? I mean font type etc.
Thanks in advance!
Dear members,
Does anyone know if thereīs a way to change the layout of a datasheet form? I mean font type etc.
Thanks in advance!
In access options, set datasheet font.
Or
in a form, set form style to datasheet, set font.
or a temp way,
open sheet, select all, set font.
Sry, I canīt get this to work… whatever I do, everytime the font type of the datasheet form turns to the standard Calibri 11.
Adding a little more detail to Ranman's comments:
If you set the default in Access options, it will apply to all datasheets UNLESS individually set to be different
If you want to change an individual datasheet, you can change the font colour, style, colour, size from ribbon for the Home tab.
You can also change the background colour. alternate row colour & more... AND if you're not careful create a truly hideous outcome
Make sure you SAVE before closing or it will revert to the default next time it is opened
Thanks for your answers, but it's no help.
I know how to change the font type and size, but whatever I choose and save(!), the datasheet form is Always shown in Calibri 11.
It's a known Access bug and I also know there's a way to get around it (thought I read about it on this forum), but forgot the method
I find it strange though that you both don't seem to recognize this as a bug…..
I hardly ever use datasheets but i’ve never experienced this issue nor even heard of it before.
Suggest looking at the DevHut website as the owner often deals with workarounds to bugs
If it’s that well known an issue, he may have covered it
Found it!
My datasheet form was a pop up form... changing fonts in that mode doesnīt work!
Thanks for your help.