General information
Category:
Forms & Form designer
Title:
Grid formatting for calculated numeric field
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only