Ah I was trying the format mask in the properties. Just use the display format under tables and it does it for you.
Thx Dan Goldberg -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, February 16, 2016 2:38 PM To: Dan Goldberg Subject: [RBASE-L] - RE: display format in forms At 05:05 PM 2/16/2016, Dan Goldberg wrote: >No I am running 9.5 but is still under support for bug fixes. > >I will report it. FWIW ... This is not a bug. The "Display Format" for the Report/Label Designer (as an output device) is different from the "Format Mask in the Form Designer (as an enter/edit device). Basically, reports will accept "$#,0.00;($#,0.00)", but forms accept a different format. Please refer to the "Using Format Mask in Form Designer" chapter within the Forms Help file. Hope that provides you with some blue's clues ... Very Best R:egards, Razzak >From: [email protected] [mailto:[email protected]] On Behalf Of >toomas83 >Sent: Tuesday, February 16, 2016 1:57 PM >To: Dan Goldberg >Subject: [RBASE-L] - RE: display format in forms > >Are you using Rbase X, I had an issue using the format for phone >numbers and it was a bug which the dream team fixed much fast > >Tom Hart > >-------- Original message -------- >From: Dan Goldberg <<mailto:[email protected]>[email protected]> >Date: 02/16/2016 12:30 PM (GMT-06:00) >To: <mailto:[email protected]>[email protected] >Subject: [RBASE-L] - display format in forms We currently use 4 digits >on our currency format in our database. $102.2516 > >I want to be able to display only two digits on the forms and reports. > >In forms I added “$#,0.00;($#,0.00)†to the format mask. > >It displays properly but when I click on the field to change the value >it displays “$#,0.00;($#,0.00)â€. It should be the numbers in that >field. > >Has anyone have an ideas? > >TIA > >Dan Goldberg
