John W. Colby
jcolby at colbyconsulting.com
Tue Mar 4 17:21:19 CST 2003
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 I've stopped 9,258 spam messages. You can too! Get your free, safe spam protection at http://www.cloudmark.com/spamnetsig/ -----Original Message----- From: accessd-admin at databaseadvisors.com [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] 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 I've stopped 9,257 spam messages. You can too! Get your free, safe spam protection at http://www.cloudmark.com/spamnetsig/ ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 2544 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030304/c5413879/attachment-0001.bin>