Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-13-2018, 05:30 AM   #1
thorcrafty
Newly Registered User
 
Join Date: Jul 2018
Location: Wisconsin
Posts: 5
Thanks: 7
Thanked 0 Times in 0 Posts
thorcrafty is on a distinguished road
Weird redraw issue

Hi, I have a weird issue that shows up when I scroll to fast in a continuous form. I'm using Access 365 and Windows 10 Pro and a MS SQL Server 2014.

FYI, I am not the worlds best programmer or Access wizbang, this is only my second Access project.

As you can see from the image, some of the data does not draw, sometimes up to 6 rows do not draw.

The data is there if i click on the field, or if i press reset view, which calls refresh.
There is conditional formatting on Due Date, and Date Complete. Due Date is calculated from Date Received and Lead.
The database is stored on a MS SQL server, and the Query is limited to top 50.
I've tried disabling Access graphics acceleration, Windows 10 Animations, removing the conditional formatting. I tried changing the Recordset Type to Snapshot from Dynaset. All to no avail.

All told its not very complex, just a simple lookup from one table. Google has failed me at this point, Anyone have any suggestions?

Thanks in advance!

Thorcrafty

thorcrafty is offline   Reply With Quote
Old 07-13-2018, 09:55 PM   #2
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,352
Thanks: 2
Thanked 1,971 Times in 1,927 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Weird redraw issue

Quote:
Originally Posted by thorcrafty View Post
..
As you can see from the image, some of the data does not draw
No I can't see that, (I don't know your database and your data), I see there are empty fields, but if they should be so because you haven't any data in it, I don't know, so where do you expect it should be data?
Show the record source for the form.
What happen if you take away the limit of Top 50?
If you open the query direct does all data appear?
If you scroll down the form, does the data then appear?
Have you tried a Compact & Repair?
Is the form a Navigation form, I see you have other tabs on it?
Only for troubleshooting, I would create a form with fewer controls in it, then you could add one control at a time until you find the culprit one.
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
thorcrafty (08-07-2018)
Old 07-15-2018, 12:52 AM   #3
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,326
Thanks: 39
Thanked 3,339 Times in 3,234 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: Weird redraw issue

suspect the OP is talking about rows 2 and 10 where the border does not show around the controls but would be good to clarify.

If this is the case it is probably down to a slow query on sql server, slow network and/or heavy use of conditional formatting (although one of your tests implies this is not the case)

So agree with JH - need to see the recordsource to the form (if a query, then the sql to the query)

__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
thorcrafty (08-07-2018)
Old 07-15-2018, 06:38 AM   #4
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 12,279
Thanks: 62
Thanked 1,145 Times in 1,046 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Weird redraw issue

One other issue SOMETIMES comes up - and this is RARE. If your screen resolution is not high enough, you can sometimes lose the thinnest borders. Thick ones rarely get whacked this way. I run into it because a FEW (and only a few) of the older games I play will resize the screen and then, if the game crashes before I exit, it will leave it that way, wrong-sized. Then the next time I open some form in Access, if I forget to reset the screen, it "looks" wrong.

This is because the graphics rendering routines in the bowels of Windows interact with the resolution of target devices. It happens more often for printers than for screens, but the renderers are still doing what they should be doing - scaling lines to display or print consistently with the image size and resolution of the output medium. This is why you sometimes have trouble seeing something in print preview if you don't currently have a selected printer.

And yes, the rendering routines are in the bowels of Windows right next to the rest of the crap they have in there that we see but don't realize.

Anyway, the test and fix are easier to describe than the reason. A simple test for this being a renderer problem is to thicken the borders up one notch. If that doesn't fix it, then look to the other suggestions from the other able members of this forum.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
The Following User Says Thank You to The_Doc_Man For This Useful Post:
thorcrafty (08-07-2018)
Old 07-16-2018, 05:30 AM   #5
thorcrafty
Newly Registered User
 
Join Date: Jul 2018
Location: Wisconsin
Posts: 5
Thanks: 7
Thanked 0 Times in 0 Posts
thorcrafty is on a distinguished road
Re: Weird redraw issue

Thanks for all your great suggestions, I will try them out and get back to you.
Sorry for not being clearer, Row 2 and 10 are supposed to have data in them. The data disappears when I scroll to fast. The data is not deleted, if i scroll up and then down slowly, It will redraw.

Anywho, I'll try your suggestions and see what results I get.

Thanks,

Thorcrafty
thorcrafty is offline   Reply With Quote
Old 07-16-2018, 10:28 AM   #6
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 1,491
Thanks: 14
Thanked 272 Times in 270 Posts
Mark_ will become famous soon enough
Re: Weird redraw issue

The other way to deal with this is to use the On_Paint event to update your colours. This way you do one check(s) in one place and set values as needed. From what I've done this seems to work better than conditional formatting as you've one check to do rather than many for each field in each instance of the form.
Mark_ is offline   Reply With Quote
The Following User Says Thank You to Mark_ For This Useful Post:
thorcrafty (08-07-2018)
Old 07-16-2018, 01:42 PM   #7
lpapad
Newly Registered User
 
Join Date: Jul 2018
Location: Greece
Posts: 47
Thanks: 12
Thanked 4 Times in 4 Posts
lpapad is on a distinguished road
Re: Weird redraw issue

1)Make the row height bigger and test results
2) check data fields, make sure they do not have special characters, ESC characters

lpapad is offline   Reply With Quote
The Following User Says Thank You to lpapad For This Useful Post:
thorcrafty (08-07-2018)
Old 07-23-2018, 06:17 AM   #8
thorcrafty
Newly Registered User
 
Join Date: Jul 2018
Location: Wisconsin
Posts: 5
Thanks: 7
Thanked 0 Times in 0 Posts
thorcrafty is on a distinguished road
Re: Weird redraw issue

Sorry for not getting back sooner. Thanks for all your suggestions. unfortunately they had no effect.

I have confirmed that the issue will show up on other computers.
The issue will occur even if i load a single form. Not just in a navigation form.
I have dual displays at 1080. I unplugged one. Tried lowering the resolution. No effect.
Thickening the border, increasing row height, all to no avail. There are no special characters that I could find in the dataset.
The sql is:
SELECT Schedule.[Job Name], Schedule.Description, Schedule.[Sales Rep], Schedule.Drafter, Schedule.[Date Received], Schedule.Lead, Workday3([Date Received],[Lead]) AS [Due Date], Schedule.[Date Started], Schedule.[Date Completed], Schedule.Comments, Schedule.[1st Draft Dollar Amount], Schedule.[Updated Dollar Amount]
FROM Schedule
ORDER BY Schedule.[Date Received] DESC;

I think I need to go back to the drawing-board. I'm thinking that in my tinkering I may have messed up something badly enough to cause the error, but not bad enough to crash it.

I'll use the On-Paint suggestion for formatting.

Thanks for your time, I'll follow up when I'm done with the remake.
thorcrafty is offline   Reply With Quote
Old 07-23-2018, 10:08 AM   #9
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,326
Thanks: 39
Thanked 3,339 Times in 3,234 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: Weird redraw issue

it could be the form has become corrupted - try rebuilding from scratch
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
thorcrafty (08-07-2018)
Old 07-23-2018, 10:24 AM   #10
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,352
Thanks: 2
Thanked 1,971 Times in 1,927 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Weird redraw issue

Else post your database with some sample data + how to reproduce the error, zip it then you haven't 10 post yet.
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
thorcrafty (08-07-2018)
Old 08-07-2018, 06:51 AM   #11
thorcrafty
Newly Registered User
 
Join Date: Jul 2018
Location: Wisconsin
Posts: 5
Thanks: 7
Thanked 0 Times in 0 Posts
thorcrafty is on a distinguished road
Re: Weird redraw issue

Just to followup. I did rebuild the forms, and everything appears to be working properly now. I'm not sure what caused the issue, but thank you all for your great suggestions.

thorcrafty is offline   Reply With Quote
Reply

Tags
form , redraw problem , scrolling , sql 2014

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Weird issue with report reynier09 General 9 08-08-2017 05:04 AM
Weird LIKE issue Kinroan Queries 6 05-09-2013 09:43 PM
weird printing issue CarlyS Reports 3 02-07-2006 07:43 AM
weird issue jamesmor General 2 01-25-2006 05:35 AM
Subform redraw problem AndyBannister Modules & VBA 3 08-07-2002 10:46 PM




All times are GMT -8. The time now is 05:17 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World