At 10:38 AM 4/17/2009, Lawrence Lustig wrote:
I'm writing a form on which I want to display a bunch of currency
figures (aged payables and receivables) without the dollar sign or
any decimals. That is $421,187.16 should display as 421,187 with
no decimal.
Did you know that you can use the eloquent method of "Table Display
Format Mask" for any any column, at once, while in a form designer?
Here's how:
01. While in Form Designer
Main Menu | Tables | Display Format ...
Expand the Table Columns [+] > [-]
Select the Column
Notice the details on right panel, including the supported list
of Display Format Marks.
Select the first option "#,0;-#,0" to achieve your goal.
Click on [OK] button to save display format.
02. Preview the data [Ctrl + F9]
03. Save the form.
That's all there is to it!
Very Best R:egards,
Razzak.
