Hi there,
I have a banded winGrid on my form, to which I have added a summary to calculate the sum of the values in a column. Right now the value is displayed as "Sum = 9410.00" and the actual value is cut off due to the column width.
Is there a way to change the text so that it reads "Total" instead of "Sum"?
Can I make the cell in the summary wider without changing the width of the actual column? If not, is it possible to move the "Total =" to be directly on the left of the sum value?
On your summary
.DisplayFormat = "{0:" & yourFormat & "}"
Will eliminate the Sum =
The summary row width isn't independent of the column width. If you have room in your first column you can create a summary there of type formula and give the formula a string result of 'Total'.
Nick