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: 3
Thanks: 0
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,173
Thanks: 2
Thanked 1,919 Times in 1,877 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
Old Yesterday, 12:52 AM   #3
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,008
Thanks: 38
Thanked 3,241 Times in 3,139 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
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
Old Yesterday, 06:38 AM   #4
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 11,802
Thanks: 52
Thanked 1,058 Times in 967 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
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
Old Today, 05:30 AM   #5
thorcrafty
Newly Registered User
 
Join Date: Jul 2018
Location: Wisconsin
Posts: 3
Thanks: 0
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 Today, 10:28 AM   #6
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Posts: 1,235
Thanks: 13
Thanked 232 Times in 230 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 online now   Reply With Quote
Old Today, 01:42 PM   #7
lpapad
Newly Registered User
 
Join Date: Jul 2018
Location: Greece
Posts: 25
Thanks: 9
Thanked 3 Times in 3 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
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 04:05 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