Annoying visual problem with subform in datasheet/continuous form mode

[EternalMyrtle]

This was not an issue on my XP but now that I have been upgraded to Windows 7 my subforms are repeating column headers but only while scrolling. Everything looks fine until you scroll down to the bottom and then scroll back up. Then the headers show up where records should be (see pic).

If you click outside the subform, the form looks normal again.

I've tried tinkering with everything in the properties and I cannot fix it. It only happens with subforms that need to be scrolled vertically.

Please help if you can! I've spent way too long trying to get this to look normal :banghead:

 

[Galaxiom]

One work around would be to simulate the datasheet with a Continuous Form. They look better than datasheets anyway.

Move the Labels to the form header with a cut and paste. (Remove the Layout first if necessary)

 

[EternalMyrtle]

Thanks for your reply.

I already tried using continuous forms instead with the labels in the form header and I still have the problem. I also tried removing the label headers all together but now the tab labels are showing where the column headers were (see pic).

It seems like an odd glitch. I am wondering if it could have to do with the fact that the subform is embedded in a tab? But as I said, this was not an issue before.

Thanks again for trying to help.

 

[Galaxiom]

Can you post the database with enough dummy data to manifest the problem so we can see this for ourselves?

 

[EternalMyrtle]

Yes, I will certainly do that when I return to work on Tuesday.

Thanks for being willing to take a look.

 

[EternalMyrtle]

Today when I opened my db the problem was magically resolved. If it returns (and I suspect that it probably will) I will post again. Thanks again.

 

[EternalMyrtle]

Ok, I take back my previous post. The problem is still there. It is especially bad in datasheet view. It is intermittent and much more subtle in continuous mode. I will work on removing data and entering dummy data so i can post it. Thanks Galaxiom.

 

[mdlueck]

You might try decompiling your database...

NT Command Script and Documented Steps to Decompile / Compact / Compile an Access DB
http://www.access-programmers.co.uk...to_Decompile_/_Compact_/_Compile_an_Access_DB

 

[EternalMyrtle]

Hi Galaxiom,

I am posting a pared down version of the db showing only the relevant objects with dummy data. I renamed all of the objects to make it clearer.

I only left one contact in there so just open frmCurrentEmployees and click on the projects tab to see the subform with the problem.

It looks fine until you scroll all the way to the bottom and then scroll back up. Do this and you start to see column headers and sometimes the tab headers in the rows as pictured in my previous posts.

The subform on its own looks fine when scrolled. I have not tested to see if it looks okay in a non-tabbed form as the form must be tabbed.

Here is what I have already tried:

1. Decompiling and compact and repair
2. Changed every conceivable property. The subform will not be used for data entry so I changed all the allow properties to "no" and the recordset type to snapshot. I tried a bunch of other stuff, too, which I cannot remember.
3. I half-heartedly tried using the EchoOn=False code but got an error message "data member not found". Plus, it disabled the vertical scroll bar. My vba skills are extremely basic and do not believe that I know how to properly apply it. Plus, I am not convinced it will solve the problem anyway.

Thank you for your time.

 

[honeysuckle]

Did you ever get this problem solved? I am too dealing with this problem.

 

[EternalMyrtle]

Now that my computer has been upgraded from XP to Windows 7 this is no longer a problem.

 

[EternalMyrtle]

ha ha, I just read in my OP that it started happening when updated to Windows 7...

So it must have magically repaired itself. Maybe an Access update??