Subform records shake if the number of records is large

[Matin_Murad]

Enter the highest numbers into the lower rectangle, then enter. When you reach 9 numbers, the subform will vibrate....

 

[The_Doc_Man]

Doesn't do anything for me. No shaking or other strange behavior.

 

[Gasman]

I can't be doing it right?

 

[MajP]

Interesting that @docman can test this.
The issue most definitely deals with non-latin characters IMO.
Most people on english or latin based languages will get the error shown by @Gasman. I do too.
Here is the discussion why and a way to potentially fix it which is not quick.

Problem "With Communicating with OLE Server" Using Non-Latin Alphabet Databases

I kind of stop helping people on this site that post databases not developed in a Latin alphabet based database (examples Arabic, Cyrillic), because I run into too many problems that cannot be fixed without a rebuild from scratch. The problem I see often is this message when I try to modify...

www.access-programmers.co.uk

 

[MajP]

I do not know if there is some setting latin based dbs can apply to avoid this error. I thought there was some settings for Unicode standard and ANSI but I do not see anything. The only thing I see is maybe some language settings.
@The_Doc_Man do you have any languages loaded.

But if someone want to fix it then follow @sonic8 advice. At least it worked for me.

Save the form as a text file and it will be obvious.

So where you see something like Caption with a non-latin property, put a latin alphabet text.
Then Loadfromtext once you fixed all non-latin Names or property values.

Actually I do not think it is the properties that you need to worry about, but definitely it is the Names of objects
The below is definitely a problem

So do a text find on "Name =" and validate all of the object names

For those developing in non-latin languages
ALWAYS USE LATIN ALPHABET FOR ANY OBJECT NAMES if you want others to look at it.

 

[The_Doc_Man]

@The_Doc_Man do you have any languages loaded.

Not that I recall, but the kit I'm using is Office 2021 LTSC originally from Germany and bought through a Canadian reseller. I'm pretty sure I did NOT choose an alternate language, because Office doesn't support Cajun French. All I think I have is English.

Just for clarity, it gives me the usual warnings about code being disabled. I tried it both ways, launching Access separately for "with" and "without" code enabled. No difference.

EDIT: Went back and checked: File >> Options >> Language... same as MajP's display. English for both option boxes.

 

[isladogs]

I do have several other languages installed including Greek.
As an experiment, I replaced all Arabic object names and captions and changed the Office language to Greek
I still get the error message

Perhaps @The_Doc_Man was entering data directly into the subform which works without error

 

[The_Doc_Man]

After reading what others said, I was able to reproduce the displayed error, but nothing "vibrated" when I hit the enter key. Colin, you are correct. I guess I didn't understand the instructions.

When I looked at the properties of the subform, I noted that it pointed to something for which there is neither a table entry nor a query entry nor a macro entry. The Latin-alphabet name was fary2, and I only saw a fary1.