<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: [AccessD] default values for combos with lists</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=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></BODY></HTML>