Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid formatting for calculated numeric field
Message
From
21/04/2008 17:52:27
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Grid formatting for calculated numeric field
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01312253
Message ID:
01312253
Views:
75
My grid’s RecordSource is a local view with a calculated field (A * B / C) as MyResult

I’m getting a display of 1234.5678 I’m trying for 1234.57
I’m staying away from set decimals to, and set fixed, as I don’t want the .00 format throughout my form.
I tried setting the Format and InputMask to #####.## on the grid’s applicable textbox
I tried (A * B / C) * 1.00 as MyResult

What am I missing?
Bob
Next
Reply
Map
View

Click here to load this message in the networking platform