Mar 23, 2006 #1 9martin Technical User Mar 22, 2006 13 US Hello, how can I change a numeric field to only show two decimal places? Thanks, Martin
Mar 23, 2006 #2 BobSuruncle Technical User Jun 18, 2002 423 CA Right-click the field and select "Format Field" from the shortcut menu. Choose one of the formats from the Number tab or click Custom to set by hand. Bob Suruncle Upvote 0 Downvote
Right-click the field and select "Format Field" from the shortcut menu. Choose one of the formats from the Number tab or click Custom to set by hand. Bob Suruncle
Mar 23, 2006 Thread starter #3 9martin Technical User Mar 22, 2006 13 US Thanks Bob, This is what I have done in the past, but in this particular report there is not a number tab?? How can I then do a custom setting? Thanks, Martin Upvote 0 Downvote
Thanks Bob, This is what I have done in the past, but in this particular report there is not a number tab?? How can I then do a custom setting? Thanks, Martin
Mar 23, 2006 #4 synapsevampire Programmer Mar 23, 2002 20,180 US Use a formual to convert it: val({table.field}) Now you can use it instead of the field to format it as Bob suggested. -k Upvote 0 Downvote
Use a formual to convert it: val({table.field}) Now you can use it instead of the field to format it as Bob suggested. -k