Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Formatting numbers in textbox

Discussion in 'Information Technology' started by ASU, Jul 28, 2006.

  1. ASU

    ASU
    Expand Collapse
    Guest

    Need help on this one. How do I format a textbox, embeded in a userform, so
    that when I type the hour 2130 it displays 21:30.
    --
    ASU
     
  2. Loading...


  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    If it is a bound box (it displays / stores data that is saved in your table )
    and not a calculated control the you should format the "table" field as
    "short time".

    Hope this helps

    --
    Wayne
    Manchester, England.



    "ASU" wrote:

    > Need help on this one. How do I format a textbox, embeded in a userform, so
    > that when I type the hour 2130 it displays 21:30.
    > --
    > ASU
     
  4. ASU

    ASU
    Expand Collapse
    Guest

    I`m relatively new to this. How would you format the "table" field?
    --
    ASU


    "Wayne-I-M" wrote:

    > If it is a bound box (it displays / stores data that is saved in your table )
    > and not a calculated control the you should format the "table" field as
    > "short time".
    >
    > Hope this helps
    >
    > --
    > Wayne
    > Manchester, England.
    >
    >
    >
    > "ASU" wrote:
    >
    > > Need help on this one. How do I format a textbox, embeded in a userform, so
    > > that when I type the hour 2130 it displays 21:30.
    > > --
    > > ASU
     

Share This Page