At 08:56 PM 3/26/2013, Javier Valencia wrote:
I am using an enhanced grid in a form and one of the field is a
computed column
type Double. While I need as many decimals as possible for other
calculations,
in the enhanced grid I would like to display only 3 decimal
places. I have looked all over and I am not able to find a place where a
format can be used in an enhanced grid column. Is this feature available in
grids or a workaround for this situation.
Any help will be appreciated.
Javier,
Did you know that you can customize the Display Format of any column
associated
with the form table(s) using the Form Designer Display Format option?
Here's how:
01. Start R:BASE eXtreme 9.5 (32/64) for Windows
02. CONNECT dbname
03. DB Explorer | Forms | Select Form with Enhanced DB Grid Control |
Design Form
04. While in Form Designer ...
Main Menu | Tables Display Format ...
Click on appropriate table associated with Enhanced DB Grid control
Click on appropriate column
Notice all options for Display Format Mask
In your specific scenario, use the following under Current Display Format:
#0.000;-#0.000
OR
You may customize the format, as you wish.
05. Click on [OK] button to save Display Format for that particular column
associated with that particular form/table
06. Use [Ctrl + F9] or click on [Run] button to preview the form while in
form designer
That's all there is to it!
And, that is your tip of the day!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
P.S. Remember, nothing is impossible in R:BASE. You are only limited by your
knowledge and experience of R:BASE!
