Charlotte Foust
cfoust at infostatsystems.com
Tue Mar 4 18:03:00 CST 2003
Does it show "True" if you set it to "0"? Charlotte Foust -----Original Message----- From: John W. Colby [mailto:jcolby at colbyconsulting.com] Sent: Tuesday, March 04, 2003 3:45 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] default values for combos with lists No, I'm saying I set the value to 0 and it was showing me "True". John W. Colby Colby Consulting www.ColbyConsulting.com _____ I've stopped 9,258 spam messages. You can too! Get your free, safe spam protection at www.cloudmark.com <http://www.cloudmark.com/spamnet?v1> Cloudmark SpamNet - Join the fight against spam! <http://www.cloudmark.com/> -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Tuesday, March 04, 2003 6:36 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] default values for combos with lists So you're saying you set the default value to = "-1" or -1, and it's showing you 0? Charlotte Foust -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com <mailto:accessd-admin at databaseadvisors.com> ] On Behalf Of John W. Colby Sent: Tuesday, March 04, 2003 3:21 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] default values for combos with lists Nope, I'm talking about the default value. Build a combo with two columns, then make -1;True;0;False;*;All as the list of values. Place 0 in the default value. The combo will display True when it opens (or it did with me). It should display false since the 0 is the false value. John W. Colby Colby Consulting www.ColbyConsulting.com <file://www.ColbyConsulting.com> I've stopped 9,258 spam messages. You can too! Get your free, safe spam protection at http://www.cloudmark.com/spamnetsig/ <http://www.cloudmark.com/spamnetsig/> -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On <mailto:accessd-admin at databaseadvisors.com]On> Behalf Of Charlotte Foust Sent: Tuesday, March 04, 2003 5:38 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] default values for combos with lists Are you talking about the ItemData, John? That's an index that relates to the position. Charlotte Foust -----Original Message----- From: John W. Colby [mailto:jcolby at colbyconsulting.com <mailto:jcolby at colbyconsulting.com> ] Sent: Tuesday, March 04, 2003 2:27 PM To: AccessD Subject: [AccessD] default values for combos with lists I discovered today that combos that display lists use a default value that is the position, not the value of the 1st column. IOW, if a combo pulls data from a table, the default value should be a value from the leftmost column in the SQL Statement feeding data to the combo. The value in this column that matches the default value will be displayed. This same thing doesn't work for list values, in this case the number is the position in the list. John W. Colby Colby Consulting www.ColbyConsulting.com <file://www.ColbyConsulting.com> I've stopped 9,257 spam messages. You can too! Get your free, safe spam protection at http://www.cloudmark.com/spamnetsig/ <http://www.cloudmark.com/spamnetsig/> ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com <http://www.eMailBoss.com> _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd <http://databaseadvisors.com/mailman/listinfo/accessd> Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com> _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd <http://databaseadvisors.com/mailman/listinfo/accessd> Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com> ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com <http://www.eMailBoss.com> _____ Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030304/276d25a9/attachment-0001.html>