Application.SetOption fails even though copied from help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Server = SQL Server 2000 SP3a
Access = 2000 SP4

I am trying to use application.setoption as it is stated in the Access help
file, even to the extent of copying the text into my .adp

It exists in the onOpen of the main form

eg

Application.SetOption "Don't display lists where more than this number of
records read", 50000

This fails with:
"'Don't display lists where more than this number of records read' is an
invalid name"

I don't understand how this can fail, as I've copied it from the Access help
(F1).

Any ideas ?
 
If memory serves, Office 2000 help had the wrong information for several of
those options. The correct argument to set that option is 'Show Values
Limit'. 50000 isn't a legal value for the second argument, though, it's a
16-bit integer, the maximum value is 32767.

Application.SetOption "Show Values Limit", 32767
 
According to my Access 2000 Help, the "Don't display lists where ..." is the
text that is displayed in the Options window. The correct argument string is
in the second column of the Help for the 'Set Options for Visual Basic' topic.
 
:)

Thanks Brendan, I did google before asking here, but there were only a few
answers hits with no answer, thought there would be more.

Don't suppose there is an up to date version of the help file?
Do you think the web based version has been corrected? I've just tried to
search ms site for "Set Options For Visual Basic" and returned nothing.

Thanks again (I set it manually to 50,000 and it did error as you said, so
its now 30,000).
 
I couldn't say whether the Access 2000 help file has been updated, as I'm
using Access 2003. Chaim's post elsewhere in this thread seems to indicate
that it may have been. Might be worth checking the Office Update and
Downloads sections at www.microsoft.com
 
Back
Top