<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#c0c0c0>
<DIV><SPAN class=792140403-05032003><FONT face=Arial color=#0000ff
size=2>Uhhh... </FONT></SPAN></DIV>
<DIV><SPAN class=792140403-05032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=792140403-05032003><FONT face=Arial color=#0000ff size=2>There
really isn't anything further. I was rebuilding my report filter form
for my billing app. This form uses combo boxes to allow me to select
filters (in this case) for binary fields, pull all records where "something" is
true, false or "All". In order to do this, I didn't need any table, just a
value list. I created the combos and then tried to set the default value
to False (it just happens). Not billed, Not paid etc. I thought that
the default value of 0 would cause a false to display, default value of -1
would cause True to display etc. It didn't work that way. -1 didn't
display anything. 0 caused a true to display. </FONT></SPAN></DIV>
<DIV><SPAN class=792140403-05032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=792140403-05032003><FONT face=Arial color=#0000ff size=2>The
combo was set up for a two column combo with the first combo width = 0 (hidden),
with the "list" of values simply -1;True;0;False;*;All; Had those
values been pulled from a table, the a default value of -1 would have caused the
True to display, a zero would have caused a False to display and so forth.
In this case, with a list of values, a 0 was causing a True to display.
Notice that POSITION 0 is a true. IE</FONT></SPAN></DIV>
<DIV><SPAN class=792140403-05032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=792140403-05032003><FONT face=Arial color=#0000ff
size=2>-1;True</FONT></SPAN></DIV>
<DIV><SPAN class=792140403-05032003><FONT face=Arial color=#0000ff
size=2>0;False</FONT></SPAN></DIV>
<DIV><SPAN class=792140403-05032003><FONT face=Arial color=#0000ff
size=2>*;All</FONT></SPAN></DIV>
<DIV><SPAN class=792140403-05032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=792140403-05032003><FONT face=Arial color=#0000ff
size=2>-1;True is the zeroth position in the list and a zero in the default
value caused that to display</FONT></SPAN></DIV>
<DIV><SPAN class=792140403-05032003><FONT face=Arial color=#0000ff
size=2>0;False is the 1st position in the list and a 1 in the default value
caused that to display</FONT></SPAN></DIV>
<DIV><SPAN class=792140403-05032003><FONT face=Arial color=#0000ff size=2>*;all
is the 2nd position in the list and a 2 in the default value caused that to
display.</FONT></SPAN></DIV>
<DIV><SPAN class=792140403-05032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=792140403-05032003><FONT face=Arial color=#0000ff size=2>It all
makes sense in a warped "Access" kind of way, but it was unexpected and caused
me a bit of head scratching before I figured out what was
happening.</FONT></SPAN></DIV>
<P><FONT size=2>John W. Colby<BR>Colby
Consulting<BR>www.ColbyConsulting.com</FONT> </P><!-- B101699BBFB441a0907FA9947EFDF6C1 -->
<P><FONT face=Arial color=#0000ff size=2></FONT><BR>
<HR>
I've stopped <STRONG>9,263</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>Michael R
Mattys<BR><B>Sent:</B> Tuesday, March 04, 2003 10:06 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><FONT face=Arial size=2>John,</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I just started looking at this thread and I
realize you have something</FONT></DIV>
<DIV>in mind. Could you please state the significance of this discovery</DIV>
<DIV>and if it can be further investigated.</DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Mike Mattys</FONT></DIV></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>