Hi. I'm trying to set the 'format' 1

[Joshy]

Hi. I'm trying to set the 'format' and 'decimal' properties for a field
(type - "number&quot of a table using macro, so that I can round off decimals
places. Does anyone know what action I use? I think its probably one
of the many build-in functions in the "run-code" action, but which
one?
table name is [tbl_HouseData] and fields [temp1], [temp2]...
thanks

 

[DougP]

this will make the number have 2 deciaml places
In a report or form
=format(Me![temp1],"##.00&quot

In a query
Expr1: Format([temp1],"#.00&quot

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[Joshy]

thanks Man!
you rock!
joshy