home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.lang.visual.basic      MS Visual Basic discussions, NOT dot-net      10,840 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 9,361 of 10,840   
   Elef to All   
   Re: Currency Text Box in Excel Form   
   28 Mar 05 20:31:22   
   
   From: m.p.b@*toglimi*rocketmail.com   
      
   Private Sub Text1_LostFocus() 'you may also test with Change event   
       on error resume next 'to avoid errors   
       text1.text=format(ccur("0" & text1.text),"#.##0,00") 'the "0" prefix  is   
   to allow convertion to zero when text1 is empty   
   End Sub   
      
   Bye   
   Elef   
      
   "DaveA"  ha scritto nel messaggio   
   news:1112022362.368772.98580@o13g2000cwo.googlegroups.com...   
   >I am attempting to have an entry on a form that will format the entry   
   > to a currency amount.   
   >   
   > For example, if the user types 3452, I would like the form to   
   > store/display 34.52.   
   >   
   > If the user types 99, I would like the form to store/display 0.99, or   
   > .99.   
   >   
   > Any suggestions as to how to go about this?   
   >   
   > Thanks.   
   >   
   > Dave   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca