bmi calculation question

[hollyh]

so I am trying to calculate BMI

so far I have this

BMI: 703*[Weightlbs]/[Height]^2

and it works! however, I would like it to only show one or two decimal places. the ROUND statement is rounding to whole numbers

is this possible?

 

[John Big Booty]

Perhaps this article will be of some assistance.

 

[hollyh]

thanks!!

 

[hollyh]

this isnt working, maybe because its a calculated field

 

[John Big Booty]

With the form in design view try setting the Format to Fixed and the Decimal Places to 2. Note that having done this you will still see the full extent of the number if you place the cursor in that field.