<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2722.900" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<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></BODY></HTML>