<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=656541222-08072003><FONT face=Arial color=#0000ff size=2>We
solve this problem with a new window that appear like a combobox in the
position. The solution apper good but the speed to charge the data are not
good.</FONT></SPAN></DIV>
<DIV><SPAN class=656541222-08072003><FONT face=Arial color=#0000ff size=2>It's a
simple trick only</FONT></SPAN></DIV>
<DIV><SPAN class=656541222-08072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=656541222-08072003><FONT face=Arial color=#0000ff
size=2>Juan</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Drew
Wutka<BR><B>Sent:</B> martes, 08 de julio de 2003 23:26<BR><B>To:</B> 'Access
Developers discussion and problem solving'<BR><B>Subject:</B> RE: [AccessD]
Breaking the 64k limit on combo boxes<BR><BR></FONT></DIV>
<DIV><SPAN class=193572321-08072003><FONT face=Arial color=#0000ff size=2>I
tried to bypass it with code, by filling the combo from a function. I
made a table with 100,000 records, and it put 100,000 lines in the combo
dropdown, without any errors, but it didn't fill anything past 64k. I
also tried to 'trick' it, by only filling a few lines, and then try to get it
to 'slide' the source, but that didn't work either. I think the only
option would be to build a combo box window, don't know how affective that
would be though....</FONT></SPAN></DIV>
<DIV><SPAN class=193572321-08072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=193572321-08072003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Rocky Smolin - Beach
Access Software [mailto:bchacc@san.rr.com]<BR><B>Sent:</B> Tuesday, July 08,
2003 11:45 AM<BR><B>To:</B> AccessD@databaseadvisors.com<BR><B>Subject:</B>
[AccessD] Breaking the 64k limit on combo boxes<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Dear List:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Does anyone know a way to get around the
64k limit on combo boxes? Other than trapping the first few keystrokes
and filtering the row source until the number of records drops below 64k?
Any third party controls?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>MTIA</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky Smolin<BR>Beach Access
Software</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>