John W. Colby
jcolby at colbyconsulting.com
Tue Mar 4 17:46:00 CST 2003
RE: [AccessD] default values for combos with listsNo, 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
-----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] 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
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
----------------------------------------------------------------------------
----
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/38f225c2/attachment-0001.html>