datasheet view font

[Dick7Access]

win 11 / 365
Trying to make font bigger in datasheet view. form has 14 but datasheet stays at 11?
google didn't bring up anything.

My eyes are not getting any better, i think its from eating too much jambiya.

 

[The_Doc_Man]

Open your DB. Starting from the ribbon, take the File (tab) >> Options (down near the bottom) >> Datasheet. The font size for datasheets is set from that place.

 

[Dick7Access]

Open your DB. Starting from the ribbon, take the File (tab) >> Options (down near the bottom) >> Datasheet. The font size for datasheets is set from that place.

I had already done that. went back and made it 72 didn't make a difference

 

[The_Doc_Man]

OK, there is this article that might help. Might not since the method appears to be a bit involved.

Form.DatasheetFontHeight property (Access)

Office VBA reference topic

learn.microsoft.com

It deals with an obscure form property that isn't shown in the property list by default.

 

[arnelgp]

do you have this?

Home->Text Formatting

 

[Gasman]

do you have this?

Home->Text Formatting

View attachment 119394

Works for me.

 

[June7]

Unfortunately, neither of the FontSize settings will do anything for a form in Datasheet view and TextFormatting ribbon group is not available.
Yes, VBA works (code will be ignored if form is opened as Single or Continuous).

Private Sub Form_Open(Cancel As Integer)
Me.DatasheetFontHeight = 14
End Sub

Alternatively, could set form for Continuous and arrange controls to look like datasheet and set FontSize property.

 

[Pat Hartman]

Unfortunately, neither of the FontSize settings will do anything for a form in Datasheet view and TextFormatting ribbon group is not available.

Try setting the default for DS view in the Access settings menu. Then recreate the subform to see if it inherits the setting. Otherwise, you need code.

 

[June7]

Try setting the default for DS view in the Access settings menu. Then recreate the subform to see if it inherits the setting. Otherwise, you need code.

Not sure what you mean by "Access settings menu" - Properties Sheet? OP did not mention subform is involved. I did not test as subform and Datasheet is form's default.

 

[Dick7Access]

OK, there is this article that might help. Might not since the method appears to be a bit involved.

Form.DatasheetFontHeight property (Access)

Office VBA reference topic

learn.microsoft.com

It deals with an obscure form property that isn't shown in the property list by default.

thanks

 

[June7]

The code is simple for a form - see post 7. Apparently, more involved if you want to use VBA to modify table (not sure why one would).

 

[Gasman]

Or you could just buy a 27" monitor, as I have just done?

 

[isladogs]

Or you could just buy a 27" monitor, as I have just done?

Larger monitor => higher resolution => all Access interface items appear smaller

 

[Gasman]

Larger monitor => higher resolution => all Access interface items appear smaller

All I can say that without mucking around with any fonts/fonts sizes, this is what I get now?

 

[Dick7Access]

Or you could just buy a 27" monitor, as I have just done?

little difficult carrying a 27 inch monitor in to motels 35 times a year.

 

[Gasman]

little difficult carrying a 27 inch monitor in to motels 35 times a year.

Plug your laptop into the TV?
I have a 17" laptop as well. I had that at 120% until I got this monitor.

 

[Dick7Access]

Plug your laptop into the TV?
I have a 17" laptop as well. I had that at 120% until I got this monitor.

You know that thought entered my mind, but your joking right. I know its possible at home, but is it possible from a motel monitor?

 

[Gasman]

Most have HDMI I would have thought?, some might even have VGA. My TV does and I have a lead constantly plugged in, for when I needed to show anything to any visitors easily. Though I would admit, they are not as sharp as monitors.
Next time you are in a motel room, have a look.
Do you have Bluetooth on your laptop?
Do not use that adapter though, as meant to be a scam, but logic is good.

https://www.amazon.co.uk/Streaming-Device-Wireless-Mirroring-Receiver-Black/dp/B0DLW84BJ9/ref=asc_df_B0DLW84BJ9?mcid=ccc9fe3069d23871adc409e211cdd084&tag=googshopuk-21&linkCode=df0&hvadid=696386561221&hvpos=&hvnetw=g&hvrand=14563534987466985534&hvpone=&hvptwo=&hvqmt=&hvdev=m&hvdvcmdl=&hvlocint=&hvlocphy=1007460&hvtargid=pla-2394742972448&psc=1&gad_source=1

 

[Mark_]

You can also right click on your desk top to change display settings. 800x600 should make it plenty big...

 

[Dick7Access]

Most have HDMI I would have thought?, some might even have VGA. My TV does and I have a lead constantly plugged in, for when I needed to show anything to any visitors easily. Though I would admit, they are not as sharp as monitors.
Next time you are in a motel room, have a look.
Do you have Bluetooth on your laptop?
Do not use that adapter though, as meant to be a scam, but logic is good.

https://www.amazon.co.uk/Streaming-Device-Wireless-Mirroring-Receiver-Black/dp/B0DLW84BJ9/ref=asc_df_B0DLW84BJ9?mcid=ccc9fe3069d23871adc409e211cdd084&tag=googshopuk-21&linkCode=df0&hvadid=696386561221&hvpos=&hvnetw=g&hvrand=14563534987466985534&hvpone=&hvptwo=&hvqmt=&hvdev=m&hvdvcmdl=&hvlocint=&hvlocphy=1007460&hvtargid=pla-2394742972448&psc=1&gad_source=1

I have a monitor that came with my security system that I never use, only used it to program my security system. After you text thought about hooking it up to my lap top, but there would not be room to fit in the my desk in my office, would have change desk, and will probable eventually go to an open desk, without pigeon holes