Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

URGENT! Trouble with printing decimal separator 2

Status
Not open for further replies.

alexdbora

Programmer
Oct 25, 2004
25
0
0
RO
I need to print a number field in format 9.999.999,99, with <,> as decimal separator.

I made correct settings for this type in Visual Fox Pro Settings.
Meaning for 1000 Separator I was setting <.> and for Decimal Separator <,>

When I'm printing from Visual fox it's OK, but when I want to print from Windows it doesn't look good!
It's something like that 9,999,999.99

I was setting in control Panel, at <Regional and Language Option> a language with 123.456.789,00 format , but it's still printing wrong.

Please help me !
 

VFP doesn't necessarily respect the settings you make in Cotnrol Panel. You have to make the settings explicitly in VFP.

Add this code to the start of your program:

Code:
SET SET SEPARATOR TO "."
SET POINT TO ","

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)
 
Mike, small typo

Code:
SET SEPARATOR TO "."
SET POINT TO ","


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
 
I think you need to SET SYSFORMATS ON for VFP to respect your Windows settings on this stuff.

Tamar
 
Thanks a lot for all of you which answered to my question!
You saved my job !!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top