Bug fixes in Microsoft Access - Current Channel Version 2605 (Build 16.0.20026.20118)
Bug Name Issue Fixed Edge Browser Control didn't render PDFs on some machines When the Edge Browser Control was used to display a PDF, on some machines the PDF would not render at all if the registry value "HKEY_CLASSES_ROOT\.pdf\Content Type" was missing. Access now provides the missing content type, so the Edge Browser Control can render the PDF. Export to SharePoint failed for tables with both lookup fields and attachment columns When exporting an Access table to a SharePoint list, if the table contained both a lookup field and an attachment column, the export could fail with an error. The export now handles this combination correctly, so the export completes successfully. Conditional Formatting color picker showed a reduced palette in Version 2604 A regression introduced in Version 2604 caused the Conditional Formatting color picker to display a smaller set of color choices than previous versions. The full legacy color palette has been restored. Some Unicode characters displayed incorrectly in objects exported to Excel When exporting an Access object whose name contained certain extended Unicode characters, the resulting file's sheet name displayed the characters incorrectly. These characters are now preserved correctly during export. Power BI Gateway couldn't refresh semantic models from .accdb files Refreshing a Power BI semantic model that connected to a .accdb file via the on-premises gateway could fail with "Unspecified error". Connection setup has been adjusted so the gateway can successfully refresh the model. Monaco SQL view: Ctrl+Z didn't undo Ctrl+Shift+K line deletion In the new Monaco-based SQL editor, pressing Ctrl+Shift+K to delete the current line removed the line, but a subsequent Ctrl+Z would not restore it. Undo now works correctly for this and similar editing operations. Document tab text didn't scale with Windows text-size setting When the Windows display setting for text size was increased, document tab labels and the record navigation bar continued to render at the standard size, while other Access UI scaled correctly. The document tabs and record navigation bar now honor the system text-size setting. Error when editing a Long Text field after a write conflict When a write conflict occurred on a record containing a Long Text field, subsequent attempts to edit the field could fail with an error. The data path now refreshes the cached field values correctly after a conflict so that further edits succeed. Access terminated unexpectedly when reading Edge Browser Control properties in form design view In form design view, retrieving the ReadyState or LocationUrl property on an Edge Browser Control could cause Access to terminate unexpectedly. Both properties now return safely in design view. "Copy" prefix was prepended instead of appended to copied object names When duplicating a database object, Access named the copy "Copy of Form1" instead of "Form1 - Copy". This made copies of related objects sort apart from their originals in the Navigation Pane. Copy-of names now append the suffix, so related objects stay together when sorted alphabetically.
Creating a dynamic line in a row
Hi I'm trying to figure out a way to make a line that covers the entire row and sits in the middle, until a text is typed, then it starts to get shorter until it should eventually disappear as the text fills the whole row. I've tested lot's of options but none of them provided a desired solution, such as inserting a text box which just get's pushed onto the next row, etc... Unless there is a setting directly in word that would allow this, it might have to be a job for VBA, which I've never tried before. if anybody knows how to achieve this I'd be most grateful. Visual representation of the desired effect in the picture bellow done with line shapes and manual adjustment.
Remove space after Chapter number in ToC and Navigation Headings
I define a "Multilevel list" for automatic chapter numbering that does not follow the number with a space, like this: That setting does apply to Heading 1 text, but it is not incorporated into the Table of Contents or Navigation Headings: As shown in the following screenshot (yellow highlighting), both of those still insert a space after the Chapter number: How can I get at least the ToC to not insert a space after the Chapter number? Ideally how can I get the Navigation pane to respect the setting also?
How to clear persistent "Normal" style, after exporting from Google Docs
All right, this is really bugging me. I started a document in Google Docs and worked on it for several weeks. Finally needing some more advanced formatting options, I exported it to a Microsoft Word .docx file and opened it in the desktop app Microsoft Word 365 for Enterprise (Version 2403, Build 17425.20176 Click-to-Run, for Windows). From the moment I first did the import, I noticed there was something "off". The text had a background color: It's barely noticeable, but it's enough to really niggle my OCD. Especially when I discovered I couldn't remove it. It seems to be "burned into" the "Normal" style. The background color is set as a "Pattern: Clear (Custom Color(RGB(250, 250, 250)))." Okay, well I know how to unset that. But in the border/shading settings for the "Normal" style, it already seems to be unset: So I tried setting a different shading pattern, hoping that would overwrite the offending setting and then I'd be able to remove it, but no. Now there are two shading patterns set on top of each other, and I can't get to the underlying one to unset it: Really vexed now, I decided to try to hack the file. In word/styles.xml inside the .docx, I found this: I deleted the whole <w:shd> element from the XML and saved the file. Then I zipped it back up and renamed it back to .docx. But when I opened the file, it was back to its old shenanigans. I saved the file again as a different filename and hacked into the file again. The <w:shd> element had re-set itself. And sure enough, there are now two <w:shd> elements in the "Normal" style. Where is this coming from? How do I get rid of it? Is there some other, Platonic ideal, "super-Normal" style that the "Normal" style depends on? I checked the Normal.dotm template and it wasn't set there. I already tried starting a new document and copying everything from the old one to the new one, using destination styles, but somehow this transferred with the text. I suppose next I'll have to do it again, copying only text, or passing it through a plain text editor. But then I'll lose 20 pages worth of formatting, ugh.
TOC formatting as hyperlinks
Hi, I am using version 16.78 of Word on Macbook Pro. I have a document where I have a TOC which is customised, it worked fine up until now. The formatting doesn't match the style anymore, and just shows up as regular text, but as a hyperlink (blue and underlined). Clicking on it does send me to the correct heading, but it doesn't match the format style. I have removed, updated and reset the TOC, i've tried remaking the headings, I have deinstalled Word and reinstalled it again, nothing works. On Onedrive live online it does work normally, but not on my native app, even after reinstalling. My documents are saved one Onedrive, but it happens when I save Word documents that I stored locally. Does anyone know what to do to solve this?
Table Of Contents Formatting Not Matching Heading Style Formatting
In my word document (Microsoft Office Professional 2019 / .docx) all of the headings are setup using the Heading 1 style which is set for font= Arial, Size= 12, and BOLD is turned on. My table of contents is setup to use the Heading 1 style as shown: {TOC \h \z \t "Heading 1,1,Heading 2,2,Heading 3,3" } The table of contents works to capture all of the correct pages, however, where all of the headings in the document are done in all caps, the entries in the table of contents vary from all caps, all caps for the first word or two, to all lowercase as shown below. I've tried to update the Heading 1 style and then doing the "Update Field / Update Entire Table", but the text in the TOC stays the same.Cell Validation - Drop Down Lists and Text Formatting
Hi, I have a form in Excel that has a couple of drop down list options. I have my lists saved on a separate tab and i would like the options within one of the lists to repeat the specific text/cell formatting i have in place (each option has a different colour of text and cell fill applied, with mixed font sizes within the same cell). Is there a away o can do this without also adding conditional formatting to the cell that contains the drop down? CF doesn't quite give the result i am looking for as it doesn't mirror the mixed font sizing i have in place for the actual list. Would appreciate any help you can offer with this. Thank you J
