[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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030304/32d5ae67/attachment-0001.html>