You can edit a registry key to restrict ODBC linked tables to be of type "Snapshot" only.
In regedit, go to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC
Under ODBC, you'll see a DWORD value in the right-hand pane called "SnapshotOnly". Change this value to...
James,
The problem you're experiencing lies in the fact that the textboxes do not resize themselves until the print event actually occurs. If you examine the height property in the format event, you'll find that every one of them reflect the height that's set in the design -- even your memo...
Furthermore, this presents a major problem with ODBC linked or imported tables. Access 2000 now defaults the datatype for incoming precision fields to be of type Decimal, instead of type Double like Access 97 did. We've been having severe problems bringing currency and other precision fields...
Anyone notice this behavior?? Furthermore, anyone think that it is odd or potentially buggy?
Access 2000's Decimal datatype essentially defines that the number of digits to the LEFT of the decimal place is equal to the Precision - Scale. So, for example, create a table with one field set to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.