ms access 2002 runtime - error 2101

Question

We get the following error 2101 from msaccess 2002 runtime and msaccess 2003 runtime when running a report (but we do not get the error with msacess 2007, 2010 and 2013 runtimes) -

"The setting you entered isn't valid for this property" -

Here are the lines of code involved:

    For bytIndex = bytIndex To cNbMaxSize4SizeRun

        Me("txtHeaderSize" & bytIndex).Visible = False

        Me("txtDetailSize" & bytIndex).Visible = False

        Me("txtDamaged" & bytIndex).Visible = False

        Me("txtProductTotalQuantity" & bytIndex).Visible = False

        Me("txtProductDamaged" & bytIndex).Visible = False

    Next bytIndex

The OS is Windows 7 64 bits and the runtimes are installed in Program Files (x86) -

Is there a workaround or a patch available for this issue ?

Answer 1

I don't see how that code block could cause your issue. All it's doing is setting the Visible property of several controls, and that "setting" has been around for all versions of Access.

Are you sure your references are set correctly for the older versions of the runtime?

I had a similar situation where I was referring to a constant that was not available in 2002/2003, but had been introduced in 2007 or 2010. The code compiled fine, and it would run okay until it hit that constant on a machine running 2002 or 2003. Once it did, I received an error (can't remember exactly what error it was, but it was similar to what you're getting).

So be sure that you're not using any features or constants that are NOT available in 2002/2003.