<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=264591000-05032003><FONT face=Arial color=#0000ff size=2>Nope,
it shows false. That is what I am trying to say, it is using the default
value as the "position" selector, i.e. select the 0th element in the list (it is
zero based), select the 1st element in the list etc.</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT size=2>John W. Colby<BR>Colby
Consulting<BR>www.ColbyConsulting.com</FONT> </P><!-- B101699BBFB441a0907FA9947EFDF6C1 -->
<P><BR>
<HR>
I've stopped <STRONG>9,259</STRONG> spam messages. You can too!<BR>Get your
free, safe spam protection at <A
href="http://www.cloudmark.com/spamnet?v1">www.cloudmark.com</A><BR><A
href="http://www.cloudmark.com/"><IMG
alt="Cloudmark SpamNet - Join the fight against spam!"
src="http://www.cloudmark.com/img/sig_join.gif" border=0 NOSEND="1"></A><BR><!-- A0C0A2D1C85242f096A170281367BF11 -->
<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>
accessd-admin@databaseadvisors.com
[mailto:accessd-admin@databaseadvisors.com]<B>On Behalf Of </B>Charlotte
Foust<BR><B>Sent:</B> Tuesday, March 04, 2003 6:59 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] default values
for combos with lists<BR><BR></FONT></DIV>
<DIV><SPAN class=539365823-04032003><FONT face="Comic Sans MS" color=#0000ff
size=2>Does it show "True" if you set it to "0"?</FONT></SPAN></DIV>
<DIV><SPAN class=539365823-04032003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=539365823-04032003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</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> John W. Colby
[mailto:jcolby@colbyconsulting.com] <BR><B>Sent:</B> Tuesday, March 04, 2003
3:45 PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE:
[AccessD] default values for combos with lists<BR><BR></FONT></DIV>
<DIV><SPAN class=170384423-04032003><FONT face=Arial color=#0000ff
size=2>No, I'm saying I set the value to 0 and it was showing me
"True".</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT size=2>John W. Colby<BR>Colby
Consulting<BR>www.ColbyConsulting.com</FONT> </P><!-- B101699BBFB441a0907FA9947EFDF6C1 -->
<P><BR>
<HR>
I've stopped <STRONG>9,258</STRONG> spam messages. You can too!<BR>Get your
free, safe spam protection at <A
href="http://www.cloudmark.com/spamnet?v1">www.cloudmark.com</A><BR><A
href="http://www.cloudmark.com/"><IMG
alt="Cloudmark SpamNet - Join the fight against spam!"
src="http://www.cloudmark.com/img/sig_join.gif" border=0 NOSEND="1"></A><BR><!-- A0C0A2D1C85242f096A170281367BF11 -->
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com
[mailto:accessd-admin@databaseadvisors.com]<B>On Behalf Of </B>Charlotte
Foust<BR><B>Sent:</B> Tuesday, March 04, 2003 6:36 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] default
values for combos with lists<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face="Comic Sans MS" color=#0000ff size=2>So you're saying you
set the default value to = "-1" or -1, and it's showing you 0?</FONT> </P>
<P><FONT face="Comic Sans MS" color=#0000ff size=2>Charlotte Foust</FONT>
</P>
<UL>
<P><FONT face=Arial></FONT> <FONT face=Tahoma size=1>-----Original
Message-----</FONT> <BR><B><FONT face=Tahoma size=1>From:
</FONT></B> <FONT face=Tahoma
size=1>accessd-admin@databaseadvisors.com [</FONT><A
href="mailto:accessd-admin@databaseadvisors.com"><U><FONT face=Tahoma
color=#0000ff
size=1>mailto:accessd-admin@databaseadvisors.com</FONT></U></A><FONT
face=Tahoma size=1>] </FONT><B> <FONT face=Tahoma size=1>On Behalf
Of</FONT></B> <FONT face=Tahoma size=1>John W. Colby</FONT> <BR><B><FONT
face=Tahoma size=1>Sent: </FONT></B> <FONT face=Tahoma
size=1>Tuesday, March 04, 2003 3:21 PM</FONT> <BR><B><FONT face=Tahoma
size=1>To: </FONT></B> <FONT face=Tahoma
size=1>accessd@databaseadvisors.com</FONT> <BR><B><FONT face=Tahoma
size=1>Subject: </FONT></B>
<FONT face=Tahoma size=1>RE: [AccessD] default values for combos with
lists</FONT> </P>
<P><FONT face=Arial size=2>Nope, I'm talking about the default
value.</FONT> </P>
<P><FONT face=Arial size=2>Build a combo with two columns, then make
-1;True;0;False;*;All as the list of values.</FONT> <BR><FONT face=Arial
size=2>Place 0 in the default value.</FONT> <BR><FONT face=Arial
size=2>The combo will display True when it opens (or it did with
me).</FONT> <BR><FONT face=Arial size=2>It should display false since
the 0 is the false value.</FONT> </P>
<P><FONT face=Arial size=2>John W. Colby</FONT> <BR><FONT face=Arial
size=2>Colby Consulting</FONT> <BR><A
href="file://www.ColbyConsulting.com"><U><FONT face=Arial color=#0000ff
size=2>www.ColbyConsulting.com</FONT></U></A> </P><BR>
<P><FONT face=Arial size=2>I've stopped 9,258 spam messages. You can
too!</FONT> <BR><FONT face=Arial size=2>Get your free, safe spam
protection at </FONT><A
href="http://www.cloudmark.com/spamnetsig/"><U><FONT face=Arial
color=#0000ff size=2>http://www.cloudmark.com/spamnetsig/</FONT></U></A>
</P>
<P><FONT face=Arial size=2>-----Original Message-----</FONT> <BR><FONT
face=Arial size=2>From: accessd-admin@databaseadvisors.com</FONT>
<BR><FONT face=Arial size=2>[</FONT><A
href="mailto:accessd-admin@databaseadvisors.com]On"><U><FONT face=Arial
color=#0000ff
size=2>mailto:accessd-admin@databaseadvisors.com]On</FONT></U></A><FONT
face=Arial size=2> Behalf Of Charlotte Foust</FONT> <BR><FONT face=Arial
size=2>Sent: Tuesday, March 04, 2003 5:38 PM</FONT> <BR><FONT face=Arial
size=2>To: accessd@databaseadvisors.com</FONT> <BR><FONT face=Arial
size=2>Subject: RE: [AccessD] default values for combos with
lists</FONT> </P><BR>
<P><FONT face=Arial size=2>Are you talking about the ItemData,
John? That's an index that relates</FONT> <BR><FONT face=Arial
size=2>to the position.</FONT> </P>
<P><FONT face=Arial size=2>Charlotte Foust</FONT> </P>
<P><FONT face=Arial size=2>-----Original Message-----</FONT> <BR><FONT
face=Arial size=2>From: John W. Colby [</FONT><A
href="mailto:jcolby@colbyconsulting.com"><U><FONT face=Arial
color=#0000ff
size=2>mailto:jcolby@colbyconsulting.com</FONT></U></A><FONT face=Arial
size=2>] </FONT><BR><FONT face=Arial size=2>Sent: Tuesday, March 04,
2003 2:27 PM</FONT> <BR><FONT face=Arial size=2>To: AccessD</FONT>
<BR><FONT face=Arial size=2>Subject: [AccessD] default values for combos
with lists</FONT> </P><BR>
<P><FONT face=Arial size=2>I discovered today that combos that display
lists use a default value</FONT> <BR><FONT face=Arial size=2>that is the
position, not the value of the 1st column. IOW, if a combo</FONT>
<BR><FONT face=Arial size=2>pulls data from a table, the default value
should be a value from the</FONT> <BR><FONT face=Arial size=2>leftmost
column in the SQL Statement feeding data to the combo. The</FONT>
<BR><FONT face=Arial size=2>value in this column that matches the
default value will be displayed.</FONT> <BR><FONT face=Arial size=2>This
same thing doesn't work for list values, in this case the number
is</FONT> <BR><FONT face=Arial size=2>the position in the list.</FONT>
</P>
<P><FONT face=Arial size=2>John W. Colby</FONT> <BR><FONT face=Arial
size=2>Colby Consulting</FONT> <BR><A
href="file://www.ColbyConsulting.com"><U><FONT face=Arial color=#0000ff
size=2>www.ColbyConsulting.com</FONT></U></A> </P><BR>
<P><FONT face=Arial size=2>I've stopped 9,257 spam messages. You can
too!</FONT> <BR><FONT face=Arial size=2>Get your free, safe spam
protection at</FONT> <BR><A
href="http://www.cloudmark.com/spamnetsig/"><U><FONT face=Arial
color=#0000ff size=2>http://www.cloudmark.com/spamnetsig/</FONT></U></A>
</P>
<P><FONT face=Arial
size=2>----------------------------------------------------</FONT>
<BR><FONT face=Arial size=2>Is email taking over your day? Manage
your time with eMailBoss. Try it</FONT> <BR><FONT face=Arial
size=2>free! </FONT><A href="http://www.eMailBoss.com"><U><FONT
face=Arial color=#0000ff size=2>http://www.eMailBoss.com</FONT></U></A>
</P><BR>
<P><FONT face=Arial
size=2>_______________________________________________</FONT> <BR><FONT
face=Arial size=2>AccessD mailing list</FONT> <BR><FONT face=Arial
size=2>AccessD@databaseadvisors.com</FONT> <BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd"><U><FONT
face=Arial color=#0000ff
size=2>http://databaseadvisors.com/mailman/listinfo/accessd</FONT></U></A>
<BR><FONT face=Arial size=2>Website: </FONT><A
href="http://www.databaseadvisors.com"><U><FONT face=Arial color=#0000ff
size=2>http://www.databaseadvisors.com</FONT></U></A> <BR><FONT
face=Arial size=2>_______________________________________________</FONT>
<BR><FONT face=Arial size=2>AccessD mailing list</FONT> <BR><FONT
face=Arial size=2>AccessD@databaseadvisors.com</FONT> <BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd"><U><FONT
face=Arial color=#0000ff
size=2>http://databaseadvisors.com/mailman/listinfo/accessd</FONT></U></A>
<BR><FONT face=Arial size=2>Website: </FONT><A
href="http://www.databaseadvisors.com"><U><FONT face=Arial color=#0000ff
size=2>http://www.databaseadvisors.com</FONT></U></A> </P><BR><BR>
<P><FONT face=Arial
size=2>----------------------------------------------------</FONT>
<BR><FONT face=Arial size=2>Is email taking over your day? Manage
your time with eMailBoss. </FONT><BR><FONT face=Arial size=2>Try
it free! </FONT><A href="http://www.eMailBoss.com"><U><FONT
face=Arial color=#0000ff size=2>http://www.eMailBoss.com</FONT></U></A>
</P></UL></BLOCKQUOTE>
<DIV>
<HR>
</DIV>
<DIV>Is email taking over your day? Manage your time with eMailBoss. Try it
free! <A
href="http://www.eMailBoss.com">http://www.eMailBoss.com</A></DIV></BLOCKQUOTE></BLOCKQUOTE>
<DIV>
<HR>
</DIV>
<DIV>Is email taking over your day? Manage your time with eMailBoss. Try it
free! <A
href="http://www.eMailBoss.com">http://www.eMailBoss.com</A></DIV></BODY></HTML>