How to Change the Font Size of Specific Fields at Runtime with Buttons in Microsoft Access VBA

Another brilliant video. Very useful. I've implemented this but find that sometimes I need to click the buttons more than once for the action to work 😐 Any ideas?😁

Thanks Very Helpful,
Strongly Recommended.

Your a legend Richard, constantly amazed with your access knowledge, Thanks for these videos. Much appreciated 😀

Can you use a vba code to change size, style and color in the middle text of a field. Such as if I concatenate and field, I would like to perhaps change the font style to italics or something on a concatenated piece of data. "Hi there " & [ firstname] .... and have the firstname different from the rest of text

Thanks Rick for the video , How do i make a specific filed default to Caps lock font

To resize everything in Access including forms and UI, it may be easier to just change the scaling in Windows display settings (Start, Settings, System, Display, Scale and layout). That increases or deceases globally the sizes of all the user interfaces in Windows and apps. If you use a laptop with a smaller screen, increase scaling to maybe 175-200%. On desktop, set it back to 100-150%.

Changing the FontSize property doesn't work if the textbox contains a rich text field, whose font sizes are set by the embedded HTML tag <font size>. You have to use VBA to manually edit those tags. The <font size> value ranges from 1 to 6 only. Multiple font sizes can also exist within the same rich text box, and you have edit those tags individually.

I've tried making a "form resizer" Access add-on and found it to be a tremendous undertaking because you have to take into account everything: boxes, lines, buttons, tabs, subform height and width, all the controls inside the subforms, etc., and of course rich text fields. My advice to everyone is to just use Windows display scaling mentioned above.

Hi Richard. Have you been accefted by the recent Access issue where the software crashen when opening or creating a report? I read online that Microsoft is currently investigating the issue

Greetings to you
Very useful tips / technique

Just done this on Datasheet View.......speaking of which, could you do some tutorials on Datasheet View. Would love to do things like changing specific field (column) colours, add/remove filters via VBA etc. Btw, love, absolutely love your videos, best ACCESS content on YT.