Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    input mask character (access 2000)

    Hi
    Can anyone help me please?
    I am trying to enter the 0 character in the input mask of an access table. This could be the prefix for
    a telephone number.

    When I try this

    061
    I get the 61 saved when I switch to the datasheet view, but no 0
    What character do I need to enter to display the 0?

    Any help appriciated.

    thanks

    Regards

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: input mask character (access 2000)

    Check that the field is a text field not a number field. If it is a text field you should be able to use the 0 in the mask. If you still have problems get back to us.
    David Grugeon
    Brisbane Australia

  3. #3
    New Lounger
    Join Date
    Sep 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: input mask character (access 2000)

    thanks david

    I see what you mean about the text field, and it will accept the 0.
    i want to format the time to 06:30 - 08.00 hrs for example
    is it possible to do this for time, eg make it accept the 0.
    in the input mask using the date/time field type?

    Regards

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: input mask character (access 2000)

    If you have a time field you can use a mask like hh:nn. This will give you a 24 hour clock - 3:00 PM is 15:00.

    I would recommend using two fields for start time and end time and this approach for formatting.

    Another method is to use a text field with a predefined format. That could be

    <pre>00:00 - 00:00</pre>



    HTH
    David Grugeon
    Brisbane Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •