Results 1 to 17 of 17

Thread: RESOLVED ** Format - does not work

  1. Oct 15th, 2003, 07:02 AM #1
    holly
    holly is offline

    Thread Starter
    Fanatic Member holly's Avatar
    Join Date
    Aug 2002
    Location
    Somewhere on earth
    Posts
    721

    RESOLVED ** Format - does not work

    Hi

    Why will this statement not format the users input....
    VB Code:
    1. txtinformation = Format$(txtinformation.Text, "####.00")

    Thanks

    For ex:
    a user inputs a value i.e 12345 but I need the format function
    to take this number and format it accordingly so txtinformation
    would read i.e 1234.5...

    Thanks

    Last edited by holly; Oct 15th, 2003 at 07:14 AM.
    ** HOLLY **
    Reply With Quote Reply With Quote
  2. Oct 15th, 2003, 07:06 AM #2
    crptcblade
    crptcblade is offline
    The Devil crptcblade's Avatar
    Join Date
    Aug 2000
    Location
    Quetzalshacatenango
    Posts
    9,091
    If you read up on the Format function, you'll see that's not exactly how it works, but try this...
    VB Code:
    1. Format$("12345", "@@@@.")
    Laugh, and the world laughs with you. Cry, and you just water down your vodka.


    Take credit, not responsibility
    Reply With Quote Reply With Quote
  3. Oct 15th, 2003, 07:07 AM #3
    plenderj
    plenderj is offline
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359
    Or this...

    VB Code:
    1. txtInformation.Text = Left$(txtInformation.Text, Len(txtInformation.Text) - 2) & "." & Mid$(txtInformation.Text, Len(txtInformation.Text) - 1)
    Microsoft MVP : Visual Developer - Visual Basic [2004-2005]
    Reply With Quote Reply With Quote
  4. Oct 15th, 2003, 07:13 AM #4
    holly
    holly is offline

    Thread Starter
    Fanatic Member holly's Avatar
    Join Date
    Aug 2002
    Location
    Somewhere on earth
    Posts
    721
    Thanks

    Both examples work a treat......

    Thanks
    ** HOLLY **
    Reply With Quote Reply With Quote
  6. Oct 15th, 2003, 07:21 AM #5
    Buzby
    Buzby is offline
    Frenzied Member Buzby's Avatar
    Join Date
    Jan 1999
    Location
    UK
    Posts
    1,670
    Or use the masked edit box (with a mask of ####.# ) instead of the normal text box.
    'Buzby'
    Visual Basic Developer
    "I'm moving to Theory. Everything works there."
    Reply With Quote Reply With Quote
  7. Oct 15th, 2003, 07:36 AM #6
    plenderj
    plenderj is offline
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359
    Holly, you're fond of the 'ol winking aren't ya
    Microsoft MVP : Visual Developer - Visual Basic [2004-2005]
    Reply With Quote Reply With Quote
  8. Oct 15th, 2003, 09:31 AM #7
    holly
    holly is offline

    Thread Starter
    Fanatic Member holly's Avatar
    Join Date
    Aug 2002
    Location
    Somewhere on earth
    Posts
    721
    Originally posted by plenderj
    Holly, you're fond of the 'ol winking aren't ya
    Yes!! I liked to be winked at!!
    ** HOLLY **
    Reply With Quote Reply With Quote
  9. Oct 15th, 2003, 09:37 AM #8
    plenderj
    plenderj is offline
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359
    Originally posted by holly
    Yes!! I liked to be winked at!!
    Oh do you indeed
    Microsoft MVP : Visual Developer - Visual Basic [2004-2005]
    Reply With Quote Reply With Quote
  11. Oct 15th, 2003, 09:38 AM #9
    holly
    holly is offline

    Thread Starter
    Fanatic Member holly's Avatar
    Join Date
    Aug 2002
    Location
    Somewhere on earth
    Posts
    721
    YES!!
    ** HOLLY **
    Reply With Quote Reply With Quote
  12. Oct 15th, 2003, 09:39 AM #10
    plenderj
    plenderj is offline
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359
    So how's sunny manchester à la mer this time of year then ?
    Microsoft MVP : Visual Developer - Visual Basic [2004-2005]
    Reply With Quote Reply With Quote
  13. Oct 15th, 2003, 10:19 AM #11
    holly
    holly is offline

    Thread Starter
    Fanatic Member holly's Avatar
    Join Date
    Aug 2002
    Location
    Somewhere on earth
    Posts
    721
    Its Not too bad - When does the sun ever shine on Manchester?
    rain now thats a different matter!! How's sunny Ireland? or
    is Ireland as bad as Manchester?

    ** HOLLY **
    Reply With Quote Reply With Quote
  14. Oct 15th, 2003, 10:31 AM #12
    plenderj
    plenderj is offline
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359
    Ireland, the most beautiful country that ever was, being compared to Manchester?
    Not to say anything against Manchester, but I'm offended
    Microsoft MVP : Visual Developer - Visual Basic [2004-2005]
    Reply With Quote Reply With Quote
  15. Oct 15th, 2003, 10:43 AM #13
    holly
    holly is offline

    Thread Starter
    Fanatic Member holly's Avatar
    Join Date
    Aug 2002
    Location
    Somewhere on earth
    Posts
    721
    Originally posted by plenderj
    Ireland, the most beautiful country that ever was, being compared to Manchester?
    Not to say anything against Manchester, but I'm offended
    Whats wrong with comparing Ireland to Manchester? Whats
    wrong with Manchester?????

    I was not comparing manchester to ireland, i was merely interested in the weather? I've heard it rains alot........
    ** HOLLY **
    Reply With Quote Reply With Quote
  16. Oct 15th, 2003, 10:45 AM #14
    plenderj
    plenderj is offline
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359
    *mutters to self*
    Yeah it does have a habit of raining from time to time. Suppose its something to do with us protecting you from the Atlantic
    Microsoft MVP : Visual Developer - Visual Basic [2004-2005]
    Reply With Quote Reply With Quote
  17. Oct 15th, 2003, 10:52 AM #15
    holly
    holly is offline

    Thread Starter
    Fanatic Member holly's Avatar
    Join Date
    Aug 2002
    Location
    Somewhere on earth
    Posts
    721
    Slap myself....
    How could I forget! Well atleast Ireland is good for
    something!!!

    ** HOLLY **
    Reply With Quote Reply With Quote
  18. Oct 15th, 2003, 11:04 AM #16
    plenderj
    plenderj is offline
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359
    Originally posted by holly
    Slap myself....
    How could I forget! Well atleast Ireland is good for
    something!!!

    *jamie ponders what britain's there for ....*

    Hmmmm. Can't think of anything
    Microsoft MVP : Visual Developer - Visual Basic [2004-2005]
    Reply With Quote Reply With Quote
  19. Oct 15th, 2003, 11:07 AM #17
    holly
    holly is offline

    Thread Starter
    Fanatic Member holly's Avatar
    Join Date
    Aug 2002
    Location
    Somewhere on earth
    Posts
    721
    I'll leave that one with you....Its time to go home.... Nice
    talking to you..... (plenty winks)
    ** HOLLY **
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width