Design View under the Home menu fails on one computer

[Ed Bitzer]

The Problem covered in “The Home | View Options no longer works” on Sept 2 and marked Solved is back again. The Design View and Datasheet View on any access program of my BlackBeast(newer computer) or programs copied from the Dell backup computer. If I move back to the Dell they work fine. I conclude that the problem has to do with my BlackBeast.
I tried harder this time to comply with good forum proactice and identified clearly the versions of the two computers:
Blackbeast
Windwos 10 Home Versopm 22H2 OS Build 19045.62382
Office 365 MSO Access Version 2508 Build 16.0.19127) 64-bit
Dell:


Windwos 10 Home Versopm 22H2 OS Build 190456282
Office 365 MSO Access( Version 2507 Build 16.0.19029.20136)127) 64-bit
Both compures have the same display setting for view 125%

I attempted have also attached a zipped copy of a test program from my Black Beast rather than the Dell wondering if this copy would fail. Gave up trying to follow the instructions which had been suggested ( To attach file: https://www.accessforums.net/showthread.php?t=70301) Appears the Go Advanced option is only available on a repy so am going to attempt to immediately reply to this message

Here is a jpg of the failure appearance when you select Design View from the Home top menu. This was was copied as almost a whole screen and I see in the Preview its full page width here


Here again are some detail of the two computers I reference. My newer computer which I built in 2017, I call the e BlackBeast (Mother board - ASRock H270 M Pro4,Video - Gigabyte Radeon RX460 Direct X, CPU – Intel Core i5-7500 Quad 3.4 GHz) and 16GB of memory. T he old is a Dell 660S was purchased in 2014.

Ed

[Ed Bitzer]

Test Shr Count Example.zip

Think is managed to attached the example code which does not display the proper screen for Design. On my BlackBeast this show the lines.

Ed

[Welshgasman]

Here is what I see in design mode?
If I put 26 into the control I get a msgbox for that value and then a query of data?

[davegri]

I think what you are seeing is the property sheet stretched across the screen. To verify, try clicking on the ribbon "Add Existing Fields" (which does not have lines).
If lines go away, that is the problem. Try dragging the display from the left side to resize the property sheet.

[mike60smart]

The Form opens as it should.

When I enter any value, be it a date <=01/08/2025 or just a numeric value it opens the query "MyTempQuery" and displays 276 records

[isladogs]

I think what you are seeing is the property sheet stretched across the screen. To verify, try clicking on the ribbon "Add Existing Fields" (which does not have lines).
If lines go away, that is the problem. Try dragging the display from the left side to resize the property sheet.

Agree with @davegri
The AZ button at the top right is part of the property sheet. Reduce its width and your problem should be solved

Having said that there is a reported bug in Current Channel v2507/2508 whereby Datasheet View cannot be selected via the context menu even where that view is allowed in the property sheet. However, I don't believe that is the cause of your problem.

[Welshgasman]

I think @davegri has hit the nail on the head.
Somehow you have managed to make them overlap?

[jojowhite]

you may try to hover on the Property Sheet titlebar, and when the cursor turns to 4-headed arrow, you double click the area to dock the Property Sheet.

[Welshgasman]

you may try to hover on the Property Sheet titlebar, and when the cursor turns to 4-headed arrow, you double click the area to dock the Property Sheet.

That does nothing for me?, however one can then drag that window to relocate it.

[isladogs]

you may try to hover on the Property Sheet title bar, and when the cursor turns to 4-headed arrow, you double click the area to dock the Property Sheet.

Agreed. Double clicking on the title bar is probably the quickest way of restoring the property sheet in case of problems

NOTE: To undock the property sheet, hold the left mouse button down over the Property Sheet label and drag to a new position.

[Ed Bitzer]

Right on, Isladogs nailed the source of the problem. Davegri’s observation and suggestion to Add Existing Fields removed the lines, which identified it had something to do with Property Sheet. If I had located the AZ button (which I subsequently found) that would have solved. Jojowhite offered another suggestion that I hover on the Property Sheet title-bar and double click the 4-headed tool bar. Isladogs agreed with and what I actually did to correct.

I have carefully logged all these comments about the Property Sheet because I still have no idea how I caused it. I was not even aware of the Property Sheet, but I hit something to mess-up and did it a second time. So, it will probably happens again but I will know how to correct and eventually figure out what mistake I am making to cause.
Interesting that this problem is obviously associated with some retained display data in Access and carried over to any program opened.

For those of you that could not reproduce on your computer, you now know why.
Thanks again and will mark “solved” again.

Ed