<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6249.1">
<TITLE>RE: [AccessD] default values for combos with lists</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Comic Sans MS">So you're saying you set the default value to = "-1" or -1, and it's showing you 0?</FONT>
</P>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Comic Sans MS">Charlotte Foust</FONT>
</P>
<UL>
<P><FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Tahoma">-----Original Message-----</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">From: </FONT></B> <FONT SIZE=1 FACE="Tahoma">accessd-admin@databaseadvisors.com [</FONT><A HREF="mailto:accessd-admin@databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=1 FACE="Tahoma">mailto:accessd-admin@databaseadvisors.com</FONT></U></A><FONT SIZE=1 FACE="Tahoma">] </FONT><B> <FONT SIZE=1 FACE="Tahoma">On Behalf Of</FONT></B> <FONT SIZE=1 FACE="Tahoma">John W. Colby</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Sent: </FONT></B> <FONT SIZE=1 FACE="Tahoma">Tuesday, March 04, 2003 3:21 PM</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">To: </FONT></B> <FONT SIZE=1 FACE="Tahoma">accessd@databaseadvisors.com</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Subject: </FONT></B> <FONT SIZE=1 FACE="Tahoma">RE: [AccessD] default values for combos with lists</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Nope, I'm talking about the default value.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Build a combo with two columns, then make -1;True;0;False;*;All as the list of values.</FONT>
<BR><FONT SIZE=2 FACE="Arial">Place 0 in the default value.</FONT>
<BR><FONT SIZE=2 FACE="Arial">The combo will display True when it opens (or it did with me).</FONT>
<BR><FONT SIZE=2 FACE="Arial">It should display false since the 0 is the false value.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">John W. Colby</FONT>
<BR><FONT SIZE=2 FACE="Arial">Colby Consulting</FONT>
<BR><A HREF="file://www.ColbyConsulting.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">www.ColbyConsulting.com</FONT></U></A>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">I've stopped 9,258 spam messages. You can too!</FONT>
<BR><FONT SIZE=2 FACE="Arial">Get your free, safe spam protection at </FONT><A HREF="http://www.cloudmark.com/spamnetsig/"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.cloudmark.com/spamnetsig/</FONT></U></A>
</P>
<P><FONT SIZE=2 FACE="Arial">-----Original Message-----</FONT>
<BR><FONT SIZE=2 FACE="Arial">From: accessd-admin@databaseadvisors.com</FONT>
<BR><FONT SIZE=2 FACE="Arial">[</FONT><A HREF="mailto:accessd-admin@databaseadvisors.com]On"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">mailto:accessd-admin@databaseadvisors.com]On</FONT></U></A><FONT SIZE=2 FACE="Arial"> Behalf Of Charlotte Foust</FONT>
<BR><FONT SIZE=2 FACE="Arial">Sent: Tuesday, March 04, 2003 5:38 PM</FONT>
<BR><FONT SIZE=2 FACE="Arial">To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2 FACE="Arial">Subject: RE: [AccessD] default values for combos with lists</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">Are you talking about the ItemData, John? That's an index that relates</FONT>
<BR><FONT SIZE=2 FACE="Arial">to the position.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Charlotte Foust</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">-----Original Message-----</FONT>
<BR><FONT SIZE=2 FACE="Arial">From: John W. Colby [</FONT><A HREF="mailto:jcolby@colbyconsulting.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">mailto:jcolby@colbyconsulting.com</FONT></U></A><FONT SIZE=2 FACE="Arial">] </FONT>
<BR><FONT SIZE=2 FACE="Arial">Sent: Tuesday, March 04, 2003 2:27 PM</FONT>
<BR><FONT SIZE=2 FACE="Arial">To: AccessD</FONT>
<BR><FONT SIZE=2 FACE="Arial">Subject: [AccessD] default values for combos with lists</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">I discovered today that combos that display lists use a default value</FONT>
<BR><FONT SIZE=2 FACE="Arial">that is the position, not the value of the 1st column. IOW, if a combo</FONT>
<BR><FONT SIZE=2 FACE="Arial">pulls data from a table, the default value should be a value from the</FONT>
<BR><FONT SIZE=2 FACE="Arial">leftmost column in the SQL Statement feeding data to the combo. The</FONT>
<BR><FONT SIZE=2 FACE="Arial">value in this column that matches the default value will be displayed.</FONT>
<BR><FONT SIZE=2 FACE="Arial">This same thing doesn't work for list values, in this case the number is</FONT>
<BR><FONT SIZE=2 FACE="Arial">the position in the list.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">John W. Colby</FONT>
<BR><FONT SIZE=2 FACE="Arial">Colby Consulting</FONT>
<BR><A HREF="file://www.ColbyConsulting.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">www.ColbyConsulting.com</FONT></U></A>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">I've stopped 9,257 spam messages. You can too!</FONT>
<BR><FONT SIZE=2 FACE="Arial">Get your free, safe spam protection at</FONT>
<BR><A HREF="http://www.cloudmark.com/spamnetsig/"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.cloudmark.com/spamnetsig/</FONT></U></A>
</P>
<P><FONT SIZE=2 FACE="Arial">----------------------------------------------------</FONT>
<BR><FONT SIZE=2 FACE="Arial">Is email taking over your day? Manage your time with eMailBoss. Try it</FONT>
<BR><FONT SIZE=2 FACE="Arial">free! </FONT><A HREF="http://www.eMailBoss.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.eMailBoss.com</FONT></U></A>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">_______________________________________________</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD mailing list</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD@databaseadvisors.com</FONT>
<BR><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://databaseadvisors.com/mailman/listinfo/accessd</FONT></U></A>
<BR><FONT SIZE=2 FACE="Arial">Website: </FONT><A HREF="http://www.databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.databaseadvisors.com</FONT></U></A>
<BR><FONT SIZE=2 FACE="Arial">_______________________________________________</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD mailing list</FONT>
<BR><FONT SIZE=2 FACE="Arial">AccessD@databaseadvisors.com</FONT>
<BR><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://databaseadvisors.com/mailman/listinfo/accessd</FONT></U></A>
<BR><FONT SIZE=2 FACE="Arial">Website: </FONT><A HREF="http://www.databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.databaseadvisors.com</FONT></U></A>
</P>
<BR>
<BR>
<P><FONT SIZE=2 FACE="Arial">----------------------------------------------------</FONT>
<BR><FONT SIZE=2 FACE="Arial">Is email taking over your day? Manage your time with eMailBoss. </FONT>
<BR><FONT SIZE=2 FACE="Arial">Try it free! </FONT><A HREF="http://www.eMailBoss.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.eMailBoss.com</FONT></U></A>
</P>
</UL>
</BODY>
</HTML>