Forcing a number to 0 decimal places

[pmo]

I am able to change the formatting property of a field by choosing fixed then 0 in the property box.

The problem arises when I have a label that refers to a field.
eg

[Number]&" % of people are in attendance"

How do I force the [Number] to 0 decimal places?

Wayne
wayne.chris@bigpond.com

 

[hymn]

Open the form in design mode
right click on the field(Number)
goto Properties
Decimal Places = 0

Hope this helps

 

[krispi]

Try

Format([number],"#&quot & "Your Text"

HTH

Chris

 

[pmo]

Thanks for the advice. Chris with yours will the fact that you have "#" will that restrict to one digit.

I am hoping that e.g. 33.33333 may appear as 33

Wayne

 

[krispi]

No, it should simply display as a whole number to zero dp

Chris