It appears you have not yet registered with DEVPPL. To register please click here... (it's fast, easy and free!)

Forum

Log In Sponsors
Board index Programming Visual Basic Forum

Cannot Display currency in my project

Moderator: dafunkymunky

Cannot Display currency in my project

Postby jeranio on Thu Sep 20, 2007 6:24 pm

Hi

I am learning along with MSDN and i created a form and have most of everything working except I cannot display the totals as a currency. I have created my DB with MS ACCESS and stored them as currency and even text but VB refuses to display it as a currency although I checked dataformat as currency and custom. I even created a ne form within the same project but it will not display as currency. My desired format is R####.## but i keep getting #.# - no symbol nor two decimal figures.
I checked my regional settings as well but the sample program ADOLOAN shows the figures in currency format.
I tried the CCur and many other fucntions still no joy. PLEASE HELP
Can anyone shed some light on this ??
jeranio
 
Posts: 4
Joined: Thu Sep 20, 2007 6:16 pm

Postby ranjit_dutt on Mon Feb 11, 2008 12:05 pm

you can try this

format(field name,"Currency')

this may help
ranjit_dutt
 
Posts: 2
Joined: Sat Feb 02, 2008 2:15 pm


Who is online

Users browsing this forum: No registered users and 5 guests