2 Replies Latest reply on Mar 11, 2010 9:01 AM by mr.b.

    Value Lists don't display as enetered



      Value Lists don't display as enetered


      Hi Everyone,


      I have a value list which has some times of day in it, as 08:00, 08:30, 09:00 etc to set a time field for a bookings table. 


      It has been working fine but i added a load of additional layouts while trying to implement a calendar but now when i click on that field the value list shows as 08:00:00, 08:30:00, 09:00:00, ie it now displays the seconds, however the value list hasn't changed. I also haven't  changed anything about that layout in which the data is entered.


      Any idea what may be causing this?


      Many Thanx

        • 1. Re: Value Lists don't display as enetered

          Well, from a relative newbie that's discovered issues in dates that were not displaying correctly -- I would think the problem is not in the Value List but in the field displaying the results.


          You might go the field displaying the results in Edit Layout mode and then look in the Format toolbar under Time.  I think it sets options there for how the time is to be displayed, and somehow you've now got it set to display seconds.

          • 2. Re: Value Lists don't display as enetered

            Hi Leo,


            Thanx for the suggestion but sadly that's not it. The format options only change the data once it's been selected from the value list. 


            My problem is that the actual value list is displaying with seconds, whereas the value list itself only has hours and minutes in it! And for the life of me I can't work out why! A friend has been looking over my file but he also can't see the error.


            Any other suggestions, anyone?