Viewing more than 10 records in a dropdown box on a DAP

[axsprog]

I am quite skilled with Access, VBQ, ADo, etc. but to I can no longer
ignore the demands from clients to provide WEB enabled forms for their
data - so hence I have begun to develop DAP's for some.

I have discovered that my combo boxes in a header (for record
filtering) will not display more than 10 records. I have set the page
property "pages' to "All" and that cleared up the amount of records
bein filtered but I cannot seem to change the number of records
displayed in the list. It seems to be defaulting to 10 on any combo
box (I know, I know - dropdown) . I am sur I have looked at every
property for the control and the section and header - any help would be
appreciated.

axsprog
ax*****@yahoo.com

[Randy Harris]

* axsprog:

I am quite skilled with Access, VBQ, ADo, etc. but to I can no longer
ignore the demands from clients to provide WEB enabled forms for their
data - so hence I have begun to develop DAP's for some.

VBQ, ADo and DAP. Some interesting TLA's.

[Larry Linson]

The limitations of DAP are such that most find them useful only in an
organization's intranet, not on the Internet. And, in fact, the development
team has blogged that DAPs are to be "deprecated" in the next version,
Access 2007 -- the ones you have will still run, but to create new ones or
maintain existing ones, you'll have to keep Access 2003 or earlier around.

Generally, for web-enabled database applications using Microsoft tools, the
recommendation is for classic .asp (Active Server Pages) with ADO or the
newer ASP.NET with ADO.NET. There are newsgroups specifically on those
technologies available from news.microsoft.com or via the online interface
to which you can link from http://office.microsoft.com. There is also free
"express" website creation software for Microsoft Visual Studio 2005, but I
don't have the link.

Larry Linson
Microsoft Access MVP

"axsprog" <ax*****@yahoo.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...

>I am quite skilled with Access, VBQ, ADo, etc. but to I can no longer
ignore the demands from clients to provide WEB enabled forms for their
data - so hence I have begun to develop DAP's for some.

I have discovered that my combo boxes in a header (for record
filtering) will not display more than 10 records. I have set the page
property "pages' to "All" and that cleared up the amount of records
bein filtered but I cannot seem to change the number of records
displayed in the list. It seems to be defaulting to 10 on any combo
box (I know, I know - dropdown) . I am sur I have looked at every
property for the control and the section and header - any help would be
appreciated.

axsprog
ax*****@yahoo.com

[axsprog]

axsprog wrote:

I am quite skilled with Access, VBQ, ADo, etc. but to I can no longer
ignore the demands from clients to provide WEB enabled forms for their
data - so hence I have begun to develop DAP's for some.

I have discovered that my combo boxes in a header (for record
filtering) will not display more than 10 records. I have set the page
property "pages' to "All" and that cleared up the amount of records
bein filtered but I cannot seem to change the number of records
displayed in the list. It seems to be defaulting to 10 on any combo
box (I know, I know - dropdown) . I am sur I have looked at every
property for the control and the section and header - any help would be
appreciated.

axsprog
ax*****@yahoo.com

[Lyle Fairfield]

axsprog wrote:

I am quite skilled with Access, VBQ, ADo, etc. but to I can no longer
ignore the demands from clients to provide WEB enabled forms for their
data - so hence I have begun to develop DAP's for some.

I have discovered that my combo boxes in a header (for record
filtering) will not display more than 10 records. I have set the page
property "pages' to "All" and that cleared up the amount of records
bein filtered but I cannot seem to change the number of records
displayed in the list. It seems to be defaulting to 10 on any combo
box (I know, I know - dropdown) . I am sur I have looked at every
property for the control and the section and header - any help would be
appreciated.

I played around with this but like you I could find nothing that
helped. I wrote directly to the DAP's html inserting onfocus and onblur
commands, which I know work in other circumstances ... this simply made
the dropdown into a narrow line.
It's probably not very helpful to suggest that you try HTAs or simple
HTMs running in IE; these are a bit like DAPs but much more responsive
to one's needs. On the other hand they take very much longer to create.

[Lyle Fairfield]

In the morning and with coffee I was able to effect modifying the
number of rows shown in the dropdown by modifying the original SELECT
from:

<SELECT class=Style2 id=ReportsTo
style="Z-INDEX: 34; LEFT: 10.761cm; WIDTH: 3.105cm; POSITION: absolute;
TOP: 1.809cm; HEIGHT: 0.449cm"
tabIndex=16 MsoTextAlign="General"></SELECT>

to

<SELECT id=ReportsTo style="Z-INDEX:34; LEFT:10.761cm; WIDTH:3.105cm;
POSITION:absolute; TOP:1.809cm; HEIGHT:auto" tabIndex=16"
onblur="this.size=1" onfocus="this.size=25" size=1></SELECT>