Access 2007/2010's lack of automatic capitalization of function names in an external library

[cdveal]

If I create a new database application (applicationX), add a module and then add a new function called HelloWorld with a required parameter
and then call that function by typing HELLOWORLD, Access automatically corrects the capitalization to match the function declaration (HelloWorld).

If I MOVE the module containing HelloWorld into another database application (applicationY) and add a reference to applicationY to applicationX's reference
list, Access finds the HelloWorld function and prompts me for the required parameter, but it DOES NOT automatically correct the capitalization. HELLOWORLD
remains HELLOWORLD and not HelloWorld.

Just wondering why???

 

[Mike Krailo]

Did you export/import the module in the other application? That is the preferred way.

 

[cdveal]

The function was cut from applicationX and pasted into a module in applicationY (import would produce the same results).

Here are the 2 dummy apps (x & y). Notice the sample function in module1 in applicationX runs and produces output, but the function name used in applicationY is not capitalized the same.

If you remove the reference in applicationX, the sample function no longer runs!

Just wondering why it doesn't capitalize function names in external libraries like it does internally

 

[MajP]

I am guessing they just did not account for checking capitalization across external references when developing the vbide. I would think it is possible because intellisense knows the correct caps.

 

[cdveal]

Just wondering!