Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Display Numeric Field Centered without Decimal
Message
 
To
04/10/2005 15:21:17
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 6
Miscellaneous
Thread ID:
01056019
Message ID:
01056171
Views:
24
>I am sure this is an easy fix too....
>
>I have a column in a report that displays a numeric field. The field technically can hold numbers from 0.0 to ? and also can be negative. I want to display the number, without the decimal point, with the negative symbol if necessary, centered in the field. That is:
>
>3.0 should display as 3 (centered)
>-2.0 should display as -2 (centered)
>
>I am sure it is some combination of formating controls but I can't get it to work properly.
>
>Any help would be greatly appreciated.

Make Align of the field to be Centered, in Expression of the field put:
IIF(INT(TableField)==TableField,INT(TableField),TableField)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform