Thursday, September 1, 2016

Fonts and things in Microsoft Access

Microsoft Access designer tools have mostly been dormant and not improved over the years.

Query - SQL View font

Two things are cruel in SQL View. 

The SQL Text will not stay formatted and will automatically be wrapped - probably this is due to the two way interface between Query Design View and SQL View.

The font in SQL View isn't the best choice. You can change the font in SQL View but this also changes the Query Design View font.

File > Options > Object Designers > Query Design - Query design font

Expression Builder font

Put your cursor in the editable content text area of the Expression Builder. Ctrl+Mouse Scroll Wheel. Tip from Utter Access Forums

Tuesday, March 1, 2016

Insert Textbox - in Excel 2011 for the Mac

I don't have a Mac. The day will come (maybe) but in 30 years of working with Personal Computers, the only Apple I used was the Apple ][.

So once in a while, I encounter participants that bring a Mac along and the menus look different or items have different menu positions.

Today we couldn't find Insert > Textbox easily. Microsoft assures me it's there.

Also because I am so used to Windows's Right Click, that's Control + Click on the Mac.