Albert, Rehan & Razzak,
Thanks for your responses (although for some reason I haven't received Rehan's one, but I do see mention of it). Using the NUMERIC datatype when I set the variable works - thanks very much for that Albert. (Razzak - As the Display Format only applies to the columns, that presumably doesn't let me format my calculated variables calculated from those columns ?) Thank you all for your help. Regards, John Docherty From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Saturday, 9 August 2014 2:00 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Formatting Real Values in a Variable Edit Field An alternative to Rehan's reply is to use a fixed decimal format for the variable. For example, I have an input form for race times, and I offer NUMERIC 6,2 or NUMERIC 7,3 depending on whether the users are using 1/1000 second or 1/100 second for timing. Albert On 8/8/2014 3:02 AM, John Docherty wrote: I have a form which calculates various real values and then displays them in variable edit fields. (While these are for displaying values only I use them to match up with other variable edit fields which can be altered.) I would like to be able to format the values however I have not managed to work out how to do this. (Currency values are fine, but not the real values). If anyone can tell me how I can achieve this that would be much appreciated. (Format mask does not do it as that is, as I understand it, for input only.) Thank you. Regards, John Docherty
