Search results

More interesting info. I can change the font size in the VBA code editor when I use it on an UltraHD screen with the scale factor of 200%, but the same VBA environment does not allow me to do this on a screen with 300% zoom. Tested it on my UltraHD ASUS MG24UQ monitor and ASUS N552VW laptop.

It seems, the Office developers have finally fixed this problem. At least, I can set any desired font size in the VBA code editor on my UltraHD ASUS monitor in my copy of MS Access 2016 Version 1708 (Build 8431.2107 Click-to-Run).

One of our customers wants to use vbAccelerator ImageList control to store and draw 32-bit PNG images in his Access 2010 projects. We've modified this ImageList OCX to support uploading of 32-bit PNG images with translucency in the case if the development environment uses ComCtl32.dll that...

Yes, you are almost right as we still need to write some code and attach it manually to the required controls - though we do it with the Property Sheet. But thank you for suggesting this alternative way of doing what I need. At least, the code module will be less cluttered with typical...

Yes, I know that I can do something with my buttons when they get/lose input focus. I already tried changing the background color in the GotFocus/LostFocus event handlers. Unfortunately, that's a bad idea as we need to duplicate this code this for every (!) button on a form. I am still hoping...

I am using an MS Access 2016 database on an Ultra-HD screen with 282ppi. When I move the input focus to a button using the TAB key, it's very hard to recognize the focused button as the focus rectange is just a 1-pixel dotted line. Perhaps, you'll notice the focus rectangle on the first button...

I have one database originally created in MS Access 2003 in the mdb format. It was converted to the new accdb format in Access 2016. I need to make subforms on this form resizeable together with the form using the new Anchoring tool, but I can't make it work. It does work if I create a new form...

I have a form that is a part of another form (subform), but sometimes I open it as a standalone form. I need to make some changes in the form when it is opened not as a subform. I tried to find a simple Boolean function that indicates whether a form is opened as a subform, and eventually I wrote...

I have not managed to solve my problem yet. Some interesting observations. 1) I see a strange behavior with the registry key HKEY_CURRENT_USER\SOFTWARE\Microsoft\VBA\7.1\Common. If I change the FontHeight value manually using the regedit tool and launch VBA IDE, I see the font of the same size...

I do know that Notepad does not use VBA at all ;) Another forum user asked me to check whether I can change the font in other apps in my Windows. I think, a general font problem in the OS implied. Well, I can't change the font of the VBA code editor at all. When I open the Tools\Options dialog...

You just confirmed that VBA is the same for all Office apps. I can change font in Notepad. It seems, this is a problem that appears only in the Office VBA.

No, the same problem as VBA is the same.

I stumbled across this old thread, but decided to write my answer as it may help with MSFlexGrid and other ActiveX components. When we drop an ActiveX control onto an MS Access form and try to access its members in the VBA code editor using the syntax "<control_name>.", we will not see all the...

I am using Access 2016 on a laptop with an UHD screen (it's an ASUS N552VW model). I can change the font, but not its size. When I open Tools\Options, then the Editor Format tab I can change the value in the Font combobox, but any change in the Size combo is not saved and applied. Does any body...

So have you managed to solve the problem and find the real reason why it occurs? If not, you may encounter this problem in the future. If you get this problem because of the XLS file currently opened, I would try to close it automatically. You can attach to the running instance of Excel using...

After some googling, I found a way to assign ALT+<number> to switch to datasheet view and to design view without looping through view modes. I added the Run and Design View commands to the Quick Access Toolbar. When I press the ALT key, I see the numbers related to my quick commands, and they...

Thank you. I also saw these shortcuts on a page in the online Microsoft Office help center. However, this is not the thing I expected to find. I want to edit my query and switch to datasheet view immediately when I press a key or a simple keystroke. Why do I need to switch the available views in...

I open a query in design view in MS Access 2016. Are there keyboard shortcuts to switch from design view to datasheet view and vice versa?