First Published 7 Apr 2023
This short article describes a bug which affects datasheets in forms as well as queries and tables.
To replicate the bug:
a) open a datasheet and add a totals row from the ribbon.
b) Add totals data to one or more fields. It doesn't matter what totals item is used
c) Click in the totals row then scroll the records with the mouse. The totals data will overlay part of the record data for that field
d) Repeat for another field - first click in the totals row then scroll the records with the mouse. The previos field is now OK but the new field is now overlaid
e) Repeat for a field with no totals data - a similar effect occurs. All except the first two characters are overlaid with blank space. The first two characters are where the totals dropdown appears
f) Finally repeat for the first field. This time the word 'Total' overlays the data
NOTE: The bug is easily avoided! Don't click in the totals row or click in the records before scrolling
I have created a short YouTube video to demonstrate the behaviour. This is available at https://youtu.be/p-Gvg9Iw9Rc or you can click below:
I have informed the Access team and it is likely that the bug will be addressed at some point.
As the issue is a display bug and does not affect important functionality, I would expect that it isn't likely to be the the top of their list of priorities!
Please use the contact form below to let me know whether you found this article interesting/useful or if you have any questions/comments.
Please also consider making a donation towards the costs of maintaining this website. Thank you
Colin Riddington Mendip Data Systems Last Updated 7 Apr 2023
Return to Access Blog Page
Return to Top