[AccessD] default values for combos with lists

John W. Colby jcolby at colbyconsulting.com
Tue Mar 4 18:13:00 CST 2003


MessageNope, it shows false.  That is what I am trying to say, it is using
the default value as the "position" selector, i.e. select the 0th element in
the list (it is zero based), select the 1st element in the list etc.

John W. Colby
Colby Consulting
www.ColbyConsulting.com





----------------------------------------------------------------------------
----
I've stopped 9,259 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:59 PM
  To: accessd at databaseadvisors.com
  Subject: RE: [AccessD] default values for combos with lists


  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


      -----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

----------------------------------------------------------------------------
----

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/0633914d/attachment-0001.html>


More information about the AccessD mailing list