dbTalk Databases Forums  

currency in listbox

comp.databases.xbase.fox comp.databases.xbase.fox


Discuss currency in listbox in the comp.databases.xbase.fox forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vesna Martinovic
 
Posts: n/a

Default currency in listbox - 07-18-2003 , 02:39 PM






Hi,

(vfp8)

I have a table with currency field and want to display that values in
list box. I want it to have 2 decimal places and to be right justified.

I tried to put:
select TRANSFORM(Price,'9,999,999.99') into cursor c1

but it is centered, not left.

I also tied seting : set decimals to 2, set fixed on - but then it adds
2 decimal places for integer as well.

What is the best way to solve this?

Thanks in advance.

Vesna

Reply With Quote
  #2  
Old   
Cindy Winegarden
 
Posts: n/a

Default Re: currency in listbox - 07-19-2003 , 05:37 PM






Hi Vesna,

In addition to the other advice, your listbox may look better with a fixed
width font.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden (AT) mvps (DOT) org, www.cindywinegarden.com

"Vesna Martinovic" <dolenc (AT) kombank (DOT) com> wrote

Quote:
I have a table with currency field and want to display that values in
list box. I want it to have 2 decimal places and to be right justified.



Reply With Quote
  #3  
Old   
Vesna Martinovic
 
Posts: n/a

Default Re: currency in listbox - 07-21-2003 , 11:41 AM



It is not working. If I put
TRANSFORM(Price, "@B 9,999,999.99") it works and is left justified, but
TRANSFORM(Price, "@J 9,999,999.99") doesn't work

Vesna


Cindg88 (AT) nospamhere (DOT) com wrote:
Quote:
On Fri, 18 Jul 2003 12:39:56 -0700, Vesna Martinovic
dolenc (AT) kombank (DOT) com> wrote:

Hi,

(vfp8)

I have a table with currency field and want to display that values in
list box. I want it to have 2 decimal places and to be right justified.

I tried to put:
select TRANSFORM(Price,'9,999,999.99') into cursor c1

select TRANSFORM(Price, "@J9,999,999,99")
The @J is right align Function.

Don't have VFP and running right now but I believe this is correct.

but it is centered, not left.

I also tied seting : set decimals to 2, set fixed on - but then it adds
2 decimal places for integer as well.

What is the best way to solve this?

Thanks in advance.

Vesna

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.